UPDATE Documents SET EveryoneBit = 1 WHERE DocumentID IN (3291, 3293, 3284)
in query analyzer gives the same error... and EM actually adds the brackets to the query Justin > -----Original Message----- > From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] > Sent: 12 September 2002 14:07 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Stupid SQL question > > > 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] > > > -- ** 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]
