You might want to test with the:<br><br><font size="4"><span style="color: rgb(255, 0, 0);">"('[Name]'='value')"</span> </font> <br><br>expression syntax.<br><br>Best regards,<br><br>Tamas<br><br>
<br><br><br><div class="gmail_quote">2009/3/24 Murty Maganti <span dir="ltr"><<a href="mailto:MMaganti@oriongis.com">MMaganti@oriongis.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Hi </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Here is the entry in map file (removed CLASS portion)</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> LAYER</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> CONNECTION
"vmonp03,port:5154,dmtigdb,dmtigdb,password"</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> CONNECTIONTYPE PLUGIN</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> PLUGIN "msplugin_sde_92.dll"</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> DATA "DMTIGDB.CANLUR,SHAPE,SDE.DEFAULT"</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> NAME "Canlur"</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> PROCESSING "CLOSE_CONNECTION=DEFER"</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> CLASS</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> ----------</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> END</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">END</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">I think the parsing error is coming from query expression. If I use
PARCELD=123, then it writes ‘Parsing error near(PARCELID)’ to log.</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Thanks</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Murty</span></p>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> Tamas Szekeres
[mailto:<a href="mailto:szekerest@gmail.com" target="_blank">szekerest@gmail.com</a>] <br>
<b>Sent:</b> Tuesday, March 24, 2009 11:17 AM<br>
<b>To:</b> Murty Maganti<br>
<b>Cc:</b> <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
<b>Subject:</b> Re: [mapserver-users] queryByAttribute in C# mapscript</span></p>
</div><div><div></div><div class="h5">
<p> </p>
<p style="margin-bottom: 12pt;">How is your mapfile looking
like. Parsing error near (OBJECTID) seems a bit strange here....<br>
<br>
Best regards,<br>
<br>
Tamas<br>
<br>
<br>
<br>
</p>
<div>
<p>2009/3/24 Murty Maganti <<a href="mailto:MMaganti@oriongis.com" target="_blank">MMaganti@oriongis.com</a>></p>
<div>
<div>
<p>Hi</p>
<p> </p>
<p>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.</p>
<p> </p>
<p>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.</p>
<p> </p>
<p>This is what is logged by map server</p>
<p> </p>
<p>[Mon Mar 23 18:02:25 2009].834000 msConnPoolRequest(Canlur,vmonp03,port:5154,dmtigdb,dmtigdb,password)
-> got 1D49DFF8</p>
<p>[Mon Mar 23 18:02:25 2009].834000 msSDELayerOpen(): Layer Canlur specified
version SDE.DEFAULT.</p>
<p>[Mon Mar 23 18:02:25 2009].834000 msSDEGetLayerInfo(): Looking for layer by
TESTGDB.CANLUR, SHAPE, vmonp03,port:5154,dmtigdb,dmtigdb,password</p>
<p>[Mon Mar 23 18:02:25 2009].834000 msSDEGetLayerId(): Matched layer to id
112.</p>
<p>[Mon Mar 23 18:02:25 2009].834000 Getting all column information in
msSDELayerInitItemInfo</p>
<p>[Mon Mar 23 18:02:25 2009].834000 msSDELayerInitItemInfo(): getting info for
OBJECTID</p>
<p>[Mon Mar 23 18:02:25 2009].834000 msSDELayerInitItemInfo(): getting info for
CATEGORY</p>
<p>[Mon Mar 23 18:02:25 2009].834000 msSDELayerInitItemInfo(): getting info for
SHAPE</p>
<p>[Mon Mar 23 18:02:25 2009].834000 msSDELayerInitItemInfo(): getting info for
OID</p>
<p>[Mon Mar 23 18:02:35 2009].338000 getSymbol(): Symbol definition error.
Parsing error near (OBJECTID):(line 831)</p>
<p>[Mon Mar 23 18:02:35 2009].370000 msQueryByAttributes(): Search returned no
results. No matching record(s) found.</p>
<p> </p>
<p>I used another field PARCELID, which is also numeric but still does not
work.</p>
<p> </p>
<p>Thanks</p>
<p>Murty</p>
</div>
</div>
<p style="margin-bottom: 12pt;"><br>
_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a></p>
</div>
<p> </p>
</div></div></div>
</div>
</blockquote></div><br>