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
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
