[mapserver-users] queryByAttribute in C# mapscript

[Murty Maganti]

Hi

 

I am using queryByAttribute on a SDE layer with a simple expression,
'OBJECTID = 750'. The method returns MS_FAILURE, though it is valid
expression. I can run same query in ArcCatalog and get the result back.

 

What do I need to verify here. I usually I check that there is template
name defined and maxscaledenom is set to -1. What else I am missing.

 

This is what is logged by map server

 

[Mon Mar 23 18:02:25 2009].834000
msConnPoolRequest(Canlur,vmonp03,port:5154,dmtigdb,dmtigdb,password) ->
got 1D49DFF8

[Mon Mar 23 18:02:25 2009].834000 msSDELayerOpen(): Layer Canlur
specified version SDE.DEFAULT.

[Mon Mar 23 18:02:25 2009].834000 msSDEGetLayerInfo(): Looking for layer
by TESTGDB.CANLUR, SHAPE, vmonp03,port:5154,dmtigdb,dmtigdb,password

[Mon Mar 23 18:02:25 2009].834000 msSDEGetLayerId(): Matched layer to id
112.

[Mon Mar 23 18:02:25 2009].834000 Getting all column information in
msSDELayerInitItemInfo

[Mon Mar 23 18:02:25 2009].834000 msSDELayerInitItemInfo(): getting info
for OBJECTID

[Mon Mar 23 18:02:25 2009].834000 msSDELayerInitItemInfo(): getting info
for CATEGORY

[Mon Mar 23 18:02:25 2009].834000 msSDELayerInitItemInfo(): getting info
for SHAPE

[Mon Mar 23 18:02:25 2009].834000 msSDELayerInitItemInfo(): getting info
for OID

[Mon Mar 23 18:02:35 2009].338000 getSymbol(): Symbol definition error.
Parsing error near (OBJECTID):(line 831)

[Mon Mar 23 18:02:35 2009].370000 msQueryByAttributes(): Search returned
no results. No matching record(s) found.

 

I used another field PARCELID, which is also numeric but still does not
work.

 

Thanks

Murty

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090324/c937bd4c/attachment.htm>