looks fine, what error u getitng. The only thing could be the datatypes are wrong for the fields uy are using
-----Original Message----- From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] Sent: 12 September 2002 13:20 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Stupid SQL question Hi, due to lack of sleep I'm asking the question... Is there anything wrong with SQL in format as below? UPDATE Table SET Field = 1 WHERE (ID in (12,13,14)) if there is what would be the correct syntax to get the desired result.. Thanks @J -- ** 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]
