postgis with itemnquery

Richard Greenwood richard.greenwood at GMAIL.COM
Wed Nov 29 08:10:45 EST 2006


My query arguments seem to be getting cast to numeric values when I
use postgis (but not when I use shape files). For example:
   qitem=(mapnum=0009)
seems to be interpreted as
  mapnum=9
I have tried escaping the value with no success. The "mapnum" column
is a character field.

So my questions:
1. Does anyone have suggestions for escaping the value, or
constructing the query differently?
2. How can I log the actual query that is constructed and passed to postgresql?
3. What .c file is used to process itemnquery for postgis?

Thanks,
Rich

-- 
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com



More information about the mapserver-users mailing list