Daniele
I guess it's related to an insufficient escaped apostrophe (could eg. be
the "VITO D'ASIO"). There were changes in v 4.1 and it especially now
uses a newer version of jQuery which expects syntactically correct JSON.
I'll have a look at it and will try to add a patch soon. Please send me
also via private mail the full JSON string that is reported as invalid.
Regards
Armin
On 07/04/2011 15:06, moka61 wrote:
>
> 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
>
------------------------------------------------------------------------------
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