SELECT top 8* FROM SPCData, Device WHERE SPCData.SPCDitem_ID = 1 AND SPCData.SPC_Device_ID = Device.Device_ID ORDER BY SPCData_ID DESC
Douglas Brown Email: [EMAIL PROTECTED] ----- Original Message ----- From: "Brian Scandale" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 17, 2002 11:29 PM Subject: Need quick SQL Server Advice > 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 > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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