[Mapserver-users] Bad SDE query

[Jan Hartmann]

I'm not sure, but try leaving the quotes out in the second example 
(number variables can go unquoted):

([CODE] eq 5201 or [CODE] eq 5201)  # why twice the same?

Jan Hartmamm

Murray, Ross wrote:
> If I dynamically create a query of my shapefile-based map as
> 
> ('[CODE]' eq '3a' OR '[CODE]' eq '3b')
> 
> there are some darn cool results (even if I say so myself). Yet this 
> 
> ('[CODE]' eq '5201' OR '[CODE]' eq '5201')
> 
> indentically constructed query on another (SDE layer) map produces the
> following error
> 
> msSDELayerWhichShapes(): SDE error. SE_stream_query(): Invalid SQL syntax.
> (-42).
> 
> If I have the same query templates for each attempt, can anyone suggest why
> I might be getting the worse result?
> 
>  <<Murray, Ross.vcf>>