Hi everyone, Im trying to configure search.xml file for a oracle layer and when performing the search i have no results, please any idea about what i m doing wrong is welcome: * I'm using : MS4W 2.2.8, mapserv 5.2.0 , pmapper 3.2 0 - BUILD 2008-03-05, the database is oracle XE 10g Im runnig all in a ruindows xp sp2
* this is the search.xml file : <?xml version="1.0" ?> <!--<?xml-stylesheet type="text/xsl" href="stylesheet.xsl"?>--> <searchlist version="1.0"> <dataroot>$</dataroot> <searchitem name="departamentos" description="departamentos"> <layer type="oracle" name="departamentos"> <field type="n" name="GID" description="GID" wildcard="2" /> </layer> </searchitem> <searchitem name="municipios" description="Municipios"> <layer type="oracle" name="municipios"> <field type="s" name="LONGNAME" description="Municipios" wildcard="0" /> </layer> </searchitem> <searchitem name="iglesias" description="iglesias"> <layer type="oracle" name="iglesias"> <field type="s" name="LONGNAME" description="iglesias" wildcard="0" /> </layer> </searchitem> <searchitem name="campings" description="Camping"> <layer type="oracle" name="campings"> <field type="s" name="LONGNAME" description="Camping :" wildcard="0"> </field> </layer> </searchitem> </searchlist> the layer I have configured is this: #========================================== DEPARTAMENTOS ==================# #departamentos # # Start of Layer Departamentos # LAYER NAME "departamentos" TYPE polygon CONNECTIONTYPE oraclespatial CONNECTION "mapa/m...@admin" DATA "GEOMETRY FROM DEPARTAMENTOS USING UNIQUE GID" DUMP TRUE TEMPLATE "void" STATUS ON #TRANSPARENCY 70 PROJECTION "init=epsg:32062" END METADATA "DESCRIPTION" "departamentos" "RESULT_FIELDS" "DPTO, GID" "RESULT_HEADERS" "dpto, gid" "RESULT_HYPERLINK" "DPTO, GID" "ows_title" "departamentos" END # Metadata CLASS Name 'departamentos' COLOR 16 181 84 OUTLINECOLOR 0 0 0 TEMPLATE "void" END # Class END # Layer THIS IS THE PM_DEBUG.LOG i n the \incphp\xajax directory [05-May-2009 23:04:11] P.MAPPER debug info Validation of search.xml file succeeded [05-May-2009 23:04:37] P.MAPPER debug info Searcharray in search.php->getSearchParameters() Array ( [DPTO] => CHALATENANGO [mode] => search [PHPSESSID] => 5d82664df04e9a59a4c450810ad4857d ) [05-May-2009 23:04:37] P.MAPPER debug info Parameters for searchArray file: query.php->q_execAttributeQuery Array ( [DPTO] => CHALATENANGO [mode] => search [PHPSESSID] => 5d82664df04e9a59a4c450810ad4857d ) [05-May-2009 23:04:37] P.MAPPER debug info Parameters for searchParams file: query.php->q_execAttributeQuery Array ( [layerName] => departamentos [layerType] => oracle [firstFld] => DPTO [qStr] => UPPER(DPTO) LIKE '%CHALATENANGO%' ) ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users