When I configure the New SQLView, it is ok to use constant in Sql Clause, The
following code:SELECT seq, id1 AS node, id2 AS edge, cost,geom FROM
pgr_dijkstra('
SELECT gid AS id,
source::integer,
target::integer,
length::double precision AS cost
FROM crossroad',
1,9,false, false) as di
join crossroad pt
on di.id2 = pt.gid
however, when I use %x1% replace number 1??%x2% replace number 9?? the error
occured,the following code:
SELECT seq, id1 AS node, id2 AS edge, cost,geom FROM pgr_dijkstra('
SELECT gid AS id,
source::integer,
target::integer,
length::double precision AS cost
FROM crossroad',
%x1%,%x2%,false, false) as di
join crossroad pt
on di.id2 = pt.gid
the error shows: Cann't create SQL View:syntax error at or near ??,??
position:258.
I can't solve the problem thorugh varies methods, need you help .
Thank you very much for your help.
Best wishes to you._______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
