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]
