Dear List,
What is wrong ? The result of the query is o.k.
following configuration in search.xml
########################################################################
####
<!-- ms POSTGIS layer search kgnr inline option gstnr -->
<searchitem name="kg_inline_options_gstnr_pg"
description="Grundst&#252;ck">
<layer type="postgis" name="grundstuecksflaechen">
<field type="s" name="kg" description="KG:">
<definition type="options" connectiontype="inline"
firstoption="0" >
<option name="92001" value="92001"/>
<option name="92002" value="92002"/>
<option name="92003" value="92003"/>
</definition>
</field>
<field type="s" name="gstnr" description="Gstnr:" />
<!-- <sql_from>grundstuecksflaechen</sql_from> -->
<sql_where>gstlink = '[kg]'||'[gstnr]'</sql_where>
</layer>
</searchitem>
########################################################################
#############
causes this messages in pm_debug.log
########################################################################
#############
[29-Jun-2010 09:37:44] P.MAPPER debug info
Validation of search.xml file FAILED:
<br />
<b>Warning</b>: DOMDocument::schemaValidate() [<a
href='domdocument.schemavalidate'>domdocument.schemavalidate</a>]:
Element 'sql_where': This element is not expected. Expected is ( field
). in <b>/usr/share/pmapper-4.0/incphp/query/search.php</b> on line
<b>69</b><br />
[29-Jun-2010 09:37:52] P.MAPPER debug info
Parameters for searchParams
file: query.php->q_execAttributeQuery
Array
(
[layerName] => grundstuecksflaechen
[layerType] => postgis
[firstFld] => kg
[qStr] => gstlink = '92001'||'7872'
)
[29-Jun-2010 09:37:52] P.MAPPER debug info
P.MAPPER-DEBUG: squery.php/dumpPGQueryResults() - SQL Cmd:
SELECT gid,
xmin(box3d(the_geom)),
ymin(box3d(the_geom)),
xmax(box3d(the_geom)),
ymax(box3d(the_geom)),
gid,gstlink
FROM grundstuecksflaechen
WHERE gstlink = '92001'||'7872'
LIMIT 301
########################################################################
################
Karl
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
