Opened 17 years ago
Closed 17 years ago
#1964 closed defect (fixed)
queryByAttributes method fails when using simple quotes on postGIS data
Reported by: | Owned by: | ||
---|---|---|---|
Priority: | high | Milestone: | |
Component: | PostGIS Interface | Version: | 4.10 |
Severity: | normal | Keywords: | |
Cc: | sylvain.pasche@…, yjacolin@… |
Description
When using simple quotes in qstring parameter, the SQL query in postGIS is truncated. Something like the following in mapscript : $map->getLayer(0)->queryByAttributes('id', "id in '126'", MS_MULTIPLE); generates the following statement in postGIS : DECLARE mycursor [...] SELECT [...] WHERE (id in ) and (the_geom [...] Note : If needed, a test case (data + mapscript code) can be provided.
Note:
See TracTickets
for help on using tickets.