Hi folks
I downloaded 4.1.1 version stable for an update to the previous.
When I run a query on a PostGIS table I can not display the dropbox.
This is my inline search.xml
--------------------------------------------------------------------------------------------------
<searchlist version="1.0">
<dataroot>$</dataroot>
<searchitem name="com" description="Capoluoghi">
<layer type="postgis" name="capoluoghi">
<field type="s" name="nome" description="capoluoghi"
wildcard="2">
<definition type="options" connectiontype="db"
sort="asc">
<dsn
encoding="UTF-8">pgsql://user:pass@localhost/base</dsn>
<sql>SELECT DISTINCT nome, nome FROM
base.centroidi_comune WHERE nome
IS NOT NULL ORDER BY nome</sql>
</definition>
</field>
</layer>
</searchitem>
</searchlist>
---------------------------------------------------------------------------------------------------
When view pmapper log I have this result
[07-Apr-2011 14:45:29] P.MAPPER debug info
search.php->getOptionsFromDb()->json
{ "ANDREIS":"ANDREIS", "ARBA":"ARBA", ......... "VITO D'ASIO":"VITO
D\'ASIO", "ZOPPOLA":"ZOPPOLA"}
[07-Apr-2011 14:53:47] P.MAPPER debug info
XML->//definition
SimpleXMLElement Object
(
[@attributes] => Array
(
[type] => options
[connectiontype] => db
[sort] => asc
)
[dsn] => pgsql://user:paswd@localhost/base
[sql] => SELECT DISTINCT nome, nome FROM base.centroidi_comune WHERE
nome IS NOT NULL ORDER BY nome
)
sems fair...
but in firebug i notice this: invalid JSON
Invalid JSON: {"searchJson":{"searchitem": "com", "fields": [{"description":
"capoluoghi", "fldname": "nome", "fldsize": false, "fldsizedesc": false,
"fldinline": false, "definition": {"type":"options", "selectname":"nome",
"firstoption":"*", "size": 0, "events":false, "options": {
"ANDREIS":"ANDREIS",
............. }}}]}, "action":"searchitem", "divelem":"2"}
in the previous version 4.0 everything was working properly.
I also noticed that the print and download the map if it is not possible if
the map file using INCLUDE tag with other map file.
Thanks in advance
Daniele
--
View this message in context:
http://old.nabble.com/search.xml-with-postgis---invalidJSON-tp31342230p31342230.html
Sent from the pmapper users mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users