I have a query that works well with postgreSQL I just uploaded the code to a SQL Server installation and this query is failing with the Error:
--------------- Microsoft][ODBC SQL Server Driver][SQL Server]Line 7: Incorrect syntax near 'LIMIT'. SQL = "SELECT * FROM SPCData, Device WHERE SPCData.SPCDitem_ID = 1 AND SPCData.SPC_Device_ID = Device.Device_ID ORDER BY SPCData_ID DESC LIMIT 8" ---------------- My guess is that SQLSERVER has another Verb besides Limit to restrict the rows returned to 8. What would that be? Thanks, Brian ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists