[Mapserver-users] Bad SDE query

[Murray, Ross]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_000_01C29A50.FA6528F0
Content-Type: text/plain;
	charset="iso-8859-1"


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>> 

------_=_NextPart_000_01C29A50.FA6528F0
Content-Type: application/octet-stream;
	name="Murray, Ross.vcf"
Content-Disposition: attachment;
	filename="Murray, Ross.vcf"

BEGIN:VCARD
VERSION:2.1
N:Murray;Ross
FN:Murray, Ross
ORG:NRCAN.RNCAN;ESS.SST
TITLE:Information Management and GIS Technician
TEL;WORK;VOICE:947-1411 (613)
TEL;CELL;VOICE: 
ADR;WORK:;2 - 255;601 Booth Street;Ottawa;ON;K1A 0E8;CA
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:2 - 255=0D=0A601 Booth Street=0D=0AOttawa, ON K1A 0E8=0D=0ACA
EMAIL;PREF;INTERNET:rmurray at NRCan.gc.ca
REV:20020717T171556Z
END:VCARD

------_=_NextPart_000_01C29A50.FA6528F0--