Ticket #1964 (closed defect: fixed)
queryByAttributes method fails when using simple quotes on postGIS data
| Reported by: | pierre.giraud@… | Owned by: | mapserver-bugs@… |
|---|---|---|---|
| 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.
Change History
Note: See
TracTickets for help on using
tickets.
