Justin It would seem from the error message that because you have the clause in brackets its assuming it's a subquery, try it without the brackets.
Kola -----Original Message----- From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] Sent: 12 September 2002 13:46 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Stupid SQL question The error in EM I get is [ODBC][SQL Server]Subquery return more that 1 value. This is not permitted when the subquery follows =,!=,<,>,<=,=> or when the subquery is used as an expression Here is the exact SQL UPDATE Documents SET EveryoneBit = 1 WHERE (DocumentID IN (3291, 3293, 3284)) And the table def... CREATE TABLE [dbo].[Documents] ( [DocumentID] [int] IDENTITY (1, 1) NOT NULL , [DocumentName] [varchar] (50) NOT NULL , [EveryoneBit] [int] NULL , ) ON [PRIMARY] GO Justin - Tired and emotional... > -----Original Message----- > From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]] > Sent: 12 September 2002 13:17 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Stupid SQL question > > > 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] > > > -- ** 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]
