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: pmapper-users@lists.sourceforge.net > > > 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 pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users