[mapguide-users] MG 2.5 with MSSQL, compound SQL in filter fails.

Ward Kilby wkilby at telus.net
Wed Apr 3 14:43:03 PDT 2013


FDOtrace.txt <http://osgeo-org.1560.n6.nabble.com/file/n5044419/FDOtrace.txt> 
The trace logs show good SQL statements being sent except for the fact that
when using compound SQL the wrong link (OID) value is sent. With the
compound statement used in the filter no matter where one clicks on the map
to select a point only one and always the same point is highlighted as
selected. It is this erronous OID that is being sent from MGOS.

Clips of the trace log have been uploaded (hope it worked). Both sequences
resulted from selecting the same point. The first half using the LIKE 'A%'
query which worked. The second half used the LIKE 'A ' OR LIKE 'A*' which
failed. 



--
View this message in context: http://osgeo-org.1560.n6.nabble.com/MG-2-5-with-MSSQL-compound-SQL-in-filter-fails-tp5044156p5044419.html
Sent from the MapGuide Users mailing list archive at Nabble.com.


More information about the mapguide-users mailing list