Hi all,

When I use shapefile, the search function was working well. Then, when I use my 
data from PostGIS, it doesn't work anymore. I already tried the example from 
the 
DocManualsearch but I couldn't get it work.

Here is my code:

for shapefile:

<searchitem name="propinsi" description="Propinsi">
            <layer type="shape" name="propinsi">
                <field type="s" name="PROPINSI" description="Propinsi" 
wildcard="0">
                    <definition type="options" connectiontype="ms" sort="asc" 
firstoption="*">
                        <mslayer encoding="ISO-8859-1" keyfield="PROPINSI" 
showfield="PROPINSI"/>
                    </definition>
                </field>
                <field type="s" name="PROPINSI" description="Propinsi" 
wildcard="0" />
            </layer>
</searchitem>

for PostGIS:

<searchitem name="propinsi" description="Propinsi">
            <layer type="postgis" name="propinsi">
                <field type="s" name="propinsi" description="Propinsi" 
wildcard="0" />
                <definition type="options" connectiontype="db" sort="asc">
                    <dsn 
encoding="UTF-8">pgsql://postgres:postg...@localhost/mydb</dsn>
                    <sql>SELECT DISTINCT propinsi FROM country WHERE propinsi 
IS 
NOT NULL ORDER BY propinsi</sql>
                </definition>
            </field>
        </layer>
</searchitem>

Do I miss something here for this PostGIS configuration?

Thank you,

Serge


      
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Reply via email to