Could you use MAXROWS="1" in CFQUERY and just do SELECT * D -----Original Message----- From: Douglas McKenzie [mailto:[EMAIL PROTECTED]] Sent: 17 January 2003 16:46 To: CF-Dev Subject: [ cf-dev ] SQL > MySql
Got that Friday feeling so Im hoping someone can help. Need to convert this SQL: SELECT TOP 1 as maxOrderID into a statement that will work with MySql. Any ideas? Cheers, Douglas McKenzie ---------------------------------------- Internet Developer / Designer [EMAIL PROTECTED] 020 7267 6718 ---------------------------------------- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
