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
> >
> > --
> > GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
> > Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail
> >
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail
-------------------------------------------------------------------------
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
