Re: [pmapper-users] search.xml with postgis - invalidJSON in pmapper v4.2.0

2013-03-04 Thread Serge Claudio Rafanoharana
Dear Suman, I just had a quick view of you code and I think you should make the name lower case; and refer to this hint: :HINT: No function matches the given name and argument types. You might need to add explicit type casts. Please have a look at:

Re: [pmapper-users] search.xml with postgis - invalidJSON

2013-03-04 Thread Suman
thanx for help.. sorry it was silly mistake. i typed wrong spelling of option. thanx again for your help. Best Regards, Suman -- View this message in context:

Re: [pmapper-users] search.xml with postgis - invalidJSON

2013-03-03 Thread Suman
Hi all Pmapper User I am using ms4w v3.0.6. , mapserver v6.0.3, PHP v5.4.3. and pmapper 4.2.0. When I run a query on a PostGIS table I can see suggestions but when i click them no any response. This is my inline search.xml

[pmapper-users] search.xml with postgis - invalidJSON in pmapper v4.2.0

2013-03-03 Thread Suman
Hi all Pmapper User I am using ms4w v3.0.6. , mapserver v6.0.3, PHP v5.4.3. and pmapper 4.2.0. When I run a query on a PostGIS table I can see suggestions but when i click them no any response. This is my inline search.xml

Re: [pmapper-users] search.xml with postgis - invalidJSON

2013-03-03 Thread Armin Burger
this is related to old code in query/squery.php using deprecated Postgis functions. This was working with Postgis up to version 1.5.x, but not any more with v2.x where the deprecated functions have been removed. p.mapper 4.3 should have this fixed thanks to Thomas Raffin. In your case you need

Re: [pmapper-users] search.xml with postgis - invalidJSON

2011-04-14 Thread moka61
sorry for the delayed response. I tried the two suggested solutions and entering: $ searchJson = str_replace (\ \ ' ', $ searchJson) in x_search.php I will return the correct JSON string. ... Vito d 'Asio, Vito d' Asio. I also solved the problem of the INCLUDE, it was a trivial problem. the

Re: [pmapper-users] search.xml with postgis - invalidJSON

2011-04-11 Thread Thomas RAFFIN
Hi, Since jQuery 1.4.2 I had to change in incphp/x_ajax/x_search.php the JSON string returned (just before echo): $searchJson = str_replace(\\', ', $searchJson); I have the options_array2json function with addslashes. I think it is the only change I made concerning this issue (simple quotes).

Re: [pmapper-users] search.xml with postgis - invalidJSON

2011-04-10 Thread Armin Burger
On 08/04/2011 09:18, moka61 wrote: Thank you for the quick response. I removed the apostrophe from the name VITO D'ASIO and the query works correctly. The escape is made ​​only in the second part of the key JSON. for p.mapper 4.1 try the following: in

Re: [pmapper-users] search.xml with postgis - invalidJSON

2011-04-08 Thread moka61
Thank you for the quick response. I removed the apostrophe from the name VITO D'ASIO and the query works correctly. The escape is made ​​only in the second part of the key JSON. yet information.. I noticed that from version 4.10 if I use the INCLUDE tag in the map file print and export

Re: [pmapper-users] search.xml with postgis - invalidJSON

2011-04-08 Thread Thomas RAFFIN
Hi, Concerning the INCLUDE tag in mapfiles, with mapserver 5.4 or 5.6, everything is OK. Thomas. Le 08/04/2011 09:18, moka61 a écrit : Thank you for the quick response. I removed the apostrophe from the name VITO D'ASIO and the query works correctly. The escape is made ​​only in the

Re: [pmapper-users] search.xml with postgis - invalidJSON

2011-04-08 Thread moka61
Hi mrs. Raffin I am using version 5.6 of Mapserver. With version 4.0 of pmapper using INCLUDE in the mapfile export and print module work. But in version 4.1.0 and 4.1.1 work only if your mapfile is unique and not use INCLUDE tags. example: main map file that call other mapfiles INCLUDE

Re: [pmapper-users] search.xml with postgis - invalidJSON

2011-04-08 Thread Armin Burger
Daniele I cannot find any reason why the include should not work, especially not why it worked in p.mapper 4.0 and not any more in 4.1 . Maybe it is a side-effect of another issue. p.mapper uses the standard way of Mapscript for opening a map file, and I don't see any difference between

Re: [pmapper-users] search.xml with postgis - invalidJSON

2011-04-08 Thread Armin Burger
On 08/04/2011 09:18, moka61 wrote: Thank you for the quick response. I removed the apostrophe from the name VITO D'ASIO and the query works correctly. The escape is made ​​only in the second part of the key JSON. I know, the problem is that the JSON values afterwards are used by Javascript

Re: [pmapper-users] search.xml with postgis - invalidJSON

2011-04-08 Thread moka61
I cannot find any reason why the include should not work, especially not why it worked in p.mapper 4.0 and not any more in 4.1 . Maybe it is a side-effect of another issue. p.mapper uses the standard way of Mapscript for opening a map file, and I don't see any difference between recent

Re: [pmapper-users] search.xml with postgis - invalidJSON

2011-04-08 Thread Thomas RAFFIN
Have you got errors in the php log file? Maybe there could be acces rights errors (/home/sit/mapfile and /home/mapfile). Le 08/04/2011 10:46, moka61 a écrit : I cannot find any reason why the include should not work, especially not why it worked in p.mapper 4.0 and not any more in 4.1 .

Re: [pmapper-users] search.xml with postgis - invalidJSON

2011-04-08 Thread moka61
Have you got errors in the php log file? No. php log is the same as the previous post. I rediect here all errors Maybe there could be acces rights errors (/home/sit/mapfile and /home/mapfile). access rights seem to me correct. but I'll do other attempts bye -- View this message in

[pmapper-users] search.xml with postgis - invalidJSON

2011-04-07 Thread moka61
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

Re: [pmapper-users] search.xml with postgis - invalidJSON

2011-04-07 Thread Armin Burger
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