Anyone know if we have a bug open for this issue. It seems like a pretty
simple oversight that could be fixed in 5.4 if someone would champion it.
-Steve
Bob Basques wrote:
This was just talked about this past week in another thread.
I don't believe there is a method for escaping the internal quotes in
the SQL statement you show. Possible option(s) would be to add a
numeric column to the DB table/view for filtering on. Or make a call
that returns more using a different SQL filter and use EXPRESSIONs in
the Layer CLASS to filter further for display. This doesn't seem
like the economical way to do things things though.
There was some stuff done in recent versions of MapServer though in
EXPRESSIONs that may be related.
bobb
Travis Kirstine <[email protected]> 02/12/09 1:45 PM >>>
The following line does not work and I think it has something to do
with the single quotes. When I use double quotes Postgres thinks I'm
referring to a column name. Is there a way to escape the single
quotes? DATA "geom from (select id as oid, geom from some_table where
some_field = 'some_string') as myquery using SRID=-1"
The following line works because I'm doing a numeric comparison. DATA
"geom from (select id as oid, geom from some_table where
some_field_number = 99) as myquery using SRID=-1"
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
