Hi Armin,
I have modified the line 708 inside of the query.php:
function q_execAttributeQuery()
how you have suggested.
When I try to do a search, again no records result.
Inside the pm_debug there's:
Parameters for searchParams
file: query.php->q_execAttributeQuery
Array
(
[layerName] => ptcp_ai_me_sme_a
[layerType] => oracle
[firstFld] => DEFINIZION
[qStr] => UPPER(DEFINIZION) LIKE '%FORTE%'
)
If I use the same 'where condition' with sqlplus :
select * from ptcp_ai_me_sme_a where UPPER(DEFINIZION) LIKE '%FORTE%'
the query return some records.
Thanks,
Marino
> I guess I forgot to update the file 'query.php' after the testing on
Hugues' server. Try to modify line 708 to
>
> if ($this->qLayerType == "shape" || $this->qLayerType == "oracle") {
>
> and see if it works better. I will compare again both versions of this
file.
>
> For debugging info set debuglevel in config.ini to 3. You should get a
file pm_debug.log in the same directory as the PHP error log. This file
contains some debugging information, also about attribute search, e.g. the
'qStr' should be a valid Oracle WHERE clause.
>
> armin
>
> > Hi Armin,
> > I have tested the the latest beta-5.
> > I want to search some string inside the column DEFINIZION (type
varchar2)
> > but the result is always null.
> >
> > The serch.xml contains:
> >
> > <searchitem name="ptcp_ai_me_sme_a" description="Emergenza PTPC">
> > <layer type="oracle" name="ptcp_ai_me_sme_a">
> > <field type="s" name="DEFINIZION" description="Emergenza
PTPC"
> > wildcard="0" />
> > </layer>
> > </searchitem>
> > How to debug or verify the search inside the script?
> >
> > Tanks for any suggestion.
> >
> > 2007/5/11, Armin Burger <[EMAIL PROTECTED]>:
> > >
> > > With the latest beta-5 of p.mapper 3.1 attribute search should work
with
> > > Oracle Spatial.
> > >
> > > armin
> > >
> > >
> > > -------- Original-Nachricht --------
> > > Datum: Fri, 11 May 2007 11:28:33 +0200
> > > Von: "Marino Fiorito" <[EMAIL PROTECTED]>
> > > An: [email protected]
> > > Betreff: [pmapper-users] Fwd: R: Pmapper-users] Oracle Spatial
> > > Attribute Search
> > >
> > > > hi Andreas,
> > > >
> > > > I have tried to test your solution in order to search attribute in
> > > oracle
> > > > spatial, but the query don't find anything. Do you have modified
> > again
> > > > your
> > > > solution? Do you have tested well this solution?
> > > >
> > > > Thanks for any suggestion
> > > >
> > > > P.S.:
> > > > My db is oracle 10g and I want to search attribute inside a varchar
> > > column
> > > >
> > > > >> Andreas Fachathaler
> > > > >> Fri, 25 Aug 2006 13:56:29 -0000
> > > > >>
> > > > >> hi!
> > > > >>
> > > > >> I added oracle spatial attribute search to my pmapper
application.
> > > > >> If someone is interested here is what I did:
> > > > >>
> > > > >> I added the following lines to the file incphp/query/query.php :
> > > > >>
> > > > >> Between the if blocks near
> > > > >> // QUERY ON POSTGIS LAYER
> > > > >> and near
> > > > >> // QUERY ON SHAPEFILE (ETC.) LAYER
> > > > >>
> > > > >> Code:
> > > > >>
> > > > >> } // end QUERY ON POSTGIS LAYER
> > > > >>
> > > > >> // QUERY ON ORACLE SPATIAL (added by Andreas Fachathaler)
> > > > >> else if ($this->qLayerType == 8) {
> > > > >>
> > > > >> foreach ($getvars as $var => $val0) {
> > > > >> if ($var != "PHPSESSID" && $var != "qlayer" &&
$var
> > > !=
> > > > >> "dbtable" && $var != "findlist" ) {
> > > > >> $fldName = preg_replace("/\#|\*/ie", "",
$var);
> > > > >>
> > > > >>
> > > > >> $val =
> > > > >> $this->q_strDecode($_GET["$var"]);
> > > > >> $sepVals = explode(' ',$val);
> > > > >>
> > > > >> reset($sepVals);
> > > > >> While(($val = current($sepVals)) !== false) {
> > > > >>
> > > > >> $varValStr = returnVar($var, $val, "db");
> > > > >> $nextValue = next($sepVals);
> > > > >>
> > > > >> // echo $varValStr . "\n";
> > > > >>
> > > > >> if (strlen(trim($val)) > 0) {
> > > > >> $qStr .= $varValStr;
> > > > >> //$qStr .= $varValStr ;
> > > > >> if ($nextValue) {
> > > > >> $qStr .= " AND ";
> > > > >> }
> > > > >> }
> > > > >>
> > > > >> }
> > > > >> }
> > > > >> }
> > > > >>
> > > > >> //echo ("$fldName ---- $qStr");
> > > > >> @$this->qLayer->queryByAttributes($fldName, $qStr,
> > > > >> MS_MULTIPLE);
> > > > >> }
> > > > >>
> > > > >> // QUERY ON SHAPEFILE (ETC.) LAYER
> > > >
> > >
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
