There was a trigger on the table...agghhhh! Thanks all
Justin > -----Original Message----- > From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] > Sent: 12 September 2002 14:18 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Stupid SQL question > > > 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] > > > -- ** 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]
