[pmapper-users] Validation of search.xml file FAILED

[Hermann Karl]

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