pag66 wrote:
>
> The search that i send you is made for use with postgis and options value
> if it dont work for you you first should try to read the log, because
> there show all the errors of the program, then it's more easy know where
> you have the problem try to paste here the error that you have into your
> log file to give you a hand
>
>
hi,
I have resolved!
For Option:
searchitem name="comuni" description="Comuni">
<layer type="postgis" name="comuni">
<field type="s" name="nome" description="Nome Comune"
wildcard="2">
<definition type="options" connectiontype="db"
sort="asc"
firstoption="*">
<dsn
encoding="UTF-8">pgsql://postgres:[EMAIL PROTECTED]/miodb</dsn>
<sql>SELECT DISTINCT nome,nome FROM
comuni WHERE nome is NOT NULL ORDER
BY nome</sql>
<dblayer encoding="ISO-8859-1"
keyfield="nome" showfield="nome"/>
</definition>
</field>
</layer>
</searchitem>
For Suggest:
<searchitem name="loc" description="Località">
<layer type="postgis" name="loc">
<field type="s" name="denom" description="Denominazione"
wildcard="2">
<definition type="suggest" connectiontype="db"
sort="asc"
minlength="1" dependfld="cmcncd">
<dsn
encoding="UTF-8">pgsql://postgres:[EMAIL PROTECTED]/miodb</dsn>
<sql>SELECT DISTINCT denom FROM loc WHERE
denom ~* '^[search]' ORDER
BY denom</sql>
</definition>
</field>
</layer>
</searchitem>
And for Operator:
<searchitem name="geog" description="Popolazione">
<layer type="postgis" name="geog">
<field type="n" name="pop" description="Popolazione">
<definition type="operator">
<dsn
encoding="UTF-8">pgsql://postgres:[EMAIL PROTECTED]/PIT_LISUT</dsn>
<sql>SELECT DISTINCT pop FROM geog ORDER BY
pop</sql>
<option name=">" value=">"/>
<option name="=" value="="/>
<option name="<" value="<"/>
</definition>
</field>
</layer>
</searchitem>
Thanks!
-----
Salvatore Larosa
GPG: 0xE504BBE2 (FP: D9B2 CA87 81CD 1B91 E24D 3B42 D0F7 FA01 E504 BBE2)
--
View this message in context:
http://www.nabble.com/option-and-operator-definition-in-xml-tp17491766p17507700.html
Sent from the pmapper users mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
