The problem is when we send a string that represents a number, example:
Filter=<Filter><PropertyIsEqualTo><PropertyName>code_cs
</PropertyName><Literal>864000</Literal></PropertyIsEqualTo></Filter>

I get:
ERROR:  operator does not exist: character varying = integer
"code_cs"= 864000

DescribeFeatureType returns
<element name="code_cs" type="string" />

In posgis, code_cs is defined as character varying(18)

My workaround is using Like instead of EqualTo
Filter=<Filter><PropertyIsLike wildcard='*' singleChar='.' 
escape='!'><PropertyName>code_cs</PropertyName><Literal>864000</Literal></PropertyIsLike></Filter>

Is this a bug in mapserver, creating the query using a number, even if 
DescribeFeatureType returns 'string' as type?

thanks
Steve


_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to