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
