[mapserver-users] How can I do a SQL text comparison in a mapfile?

[Stephen Woodbridge]

Just opened ticket:

http://trac.osgeo.org/mapserver/ticket/2888

add yourself to the CC if you are interested in tracking it.

-Steve W

Stephen Woodbridge wrote:
> 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 <traviskirstine at gmail.com> 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
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users