[mapserver-users] Re: ODBC OGR MS SQL CONNECTION

[ibrahimsaricicek]

Hi all,

This now works, I've used * instead of listing columns..

<SrcSQL>SELECT * FROM MOBILEUNIT INNER JOIN
 MUGPSDATALOG ON MOBILEUNIT.MUID=MUGPSDATALOG.MUID WHERE
 MUGPSDATALOG.EVENTLOGID IN(SELECT MAX(EVENTLOGID) FROM MUFLEET INNER JOIN
 MUGROUP ON MUFLEET.FLEETID = MUGROUP.FLEETID INNER JOIN MOBILEUNIT ON
 MUGROUP.GROUPID = MOBILEUNIT.GROUPID INNER JOIN MUGPSDATALOG ON
 MOBILEUNIT.MUID=MUGPSDATALOG.MUID where MUFLEET.FLEETID=37144 group by
 MOBILEUNIT.MUID) ORDER BY MOBILEUNIT.PLATE</SrcSQL> 

And I'll try for ogr performance suggestions...

Regards..
-- 
View this message in context: http://n2.nabble.com/ODBC-OGR-MS-SQL-CONNECTION-tp4824960p4829220.html
Sent from the Mapserver - User mailing list archive at Nabble.com.