postgis with itemnquery

[Stephen Woodbridge]

I assume you already tried:

(mapnum='0009')
(mapnum=\'0009\')

-Steve W

Richard Greenwood wrote:
> 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
>