[pmapper-users] identify query params generate msPostGISLayerWhichShapes error

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[pmapper-users] identify query params generate msPostGISLayerWhichShapes error

moka61

Hi folks

Using version 4.1.1, but 4.0.2 also "identify query" returns no result and
brings me an error in the log files pmapper:
[MapServer Error]: msPostGISLayerWhichShapes (): Error (ERROR: operator does
not exist: @ integer integer
LINE 1: ... 0213.82825667 5095319.7420758)) ', 3004) and (gid IN (0 @
2513)).

I thought it was a problem Mapserver vers. 6 and have update to the latest
pmapper version 4.0.2, but by analyzing the parameters generated by click to
feature zoom I noticed this difference:

prameters running with Postgis not run:

javascript:PM.Map.zoom2extent('comuni','0@171','2325588.9940851+5098736.6031206+2340725.2357599+5113681.9263627','0')

parameters with shape file running:

javascript:PM.Map.zoom2extent('comuni','171','2325588.9940851+5098736.6031206+2340725.2357599+5113681.9263627','0')

The '0@' character is only difference in the idx parameter passed to the
query.
Can be a problem of how to generate the parameter pmapper?

thanks



--
View this message in context: http://old.nabble.com/identify-query-params-generate-msPostGISLayerWhichShapes-error-tp32192735p32192735.html
Sent from the pmapper users mailing list archive at Nabble.com.


------------------------------------------------------------------------------
BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
The must-attend event for mobile developers. Connect with experts.
Get tools for creating Super Apps. See the latest technologies.
Sessions, hands-on labs, demos & much more. Register early & save!
http://p.sf.net/sfu/rim-blackberry-1
_______________________________________________
pmapper-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
Reply | Threaded
Open this post in threaded view
|

Re: [pmapper-users] identify query params generate msPostGISLayerWhichShapes error

moka61

Hi folks

I noticed that that removing the variable "+layerstring" from url:

mapurl = PM_XAJAX_LOCATION +
'x_load.php?'+SID+'&mode=map&zoom_type=zoomextent&extent='+geoextent+layerstring;

from the file /pmap/javascript/src/pm.map.js  --> function zoom2extent()

identify query run

the @ character in sql query returned error.

I do not know if this can cause problems or destabilize the application but
it works!!



moka61 wrote:

>
> Hi folks
>
> Using version 4.1.1, but 4.0.2 also "identify query" returns no result and
> brings me an error in the log files pmapper:
> [MapServer Error]: msPostGISLayerWhichShapes (): Error (ERROR: operator
> does not exist: @ integer integer
> LINE 1: ... 0213.82825667 5095319.7420758)) ', 3004) and (gid IN (0 @
> 2513)).
>
> I thought it was a problem Mapserver vers. 6 and have update to the latest
> pmapper version 4.0.2, but by analyzing the parameters generated by click
> to feature zoom I noticed this difference:
>
> prameters running with Postgis not run:
>
> javascript:PM.Map.zoom2extent('comuni','0@171','2325588.9940851+5098736.6031206+2340725.2357599+5113681.9263627','0')
>
> parameters with shape file running:
>
> javascript:PM.Map.zoom2extent('comuni','171','2325588.9940851+5098736.6031206+2340725.2357599+5113681.9263627','0')
>
> The '0@' character is only difference in the idx parameter passed to the
> query.
> Can be a problem of how to generate the parameter pmapper?
>
> thanks
>
>
>
>

--
View this message in context: http://old.nabble.com/identify-query-params-generate-msPostGISLayerWhichShapes-error-tp32192735p32362263.html
Sent from the pmapper users mailing list archive at Nabble.com.


------------------------------------------------------------------------------
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
_______________________________________________
pmapper-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/pmapper-users