Nor would the first example you did surely? SELECT TOP 1 just gives the first record in the set. You could do SELECT MAX(OrderID) AS maxOrderID then. Douglas
-----Original Message----- From: Douglas McKenzie [mailto:[EMAIL PROTECTED]] Sent: 17 January 2003 16:51 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SQL > MySql That wont necessarily give me the highest orderID though, which it needs to -----Original Message----- From: Douglas Humphris [mailto:[EMAIL PROTECTED]] Sent: 17 January 2003 16:47 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SQL > MySql 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] -- ** 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]
