Sorry, This is msSQL 2000 and it is saying syntax error near ')'
I had to create a mapping table, and this table needs to now be populated with a IsConfirmed = 1 when the BO_BookingDate is not NULl in Bookings and the link is BO_ID in both tables, which I ommited from the query I posted. I know I got this to work once before, and I wrote it the way I would have thought I did it last time and to no avail, I knew I should have kept the query some where:-) I am stuck getting this to work again:-) Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -----Original Message----- From: Antony Sideropoulos [mailto:[EMAIL PROTECTED] Sent: Monday, 31 July 2006 1:06 PM To: SQL Subject: Re: Anyone explain what I am doing wrong Hi Andrew Which part is failing? The inner SELECT, or the UPDATE? Do you get an error message or unexpected results? What do you get if you dump the select statement using either syntax for null? What DB platform, etc? On 7/31/06, Andrew Scott <[EMAIL PROTECTED]> wrote: > > Anyone explain what I am doing wrong, I did this once before, but I don't > see why this shouldn't work? > > UPDATE BookingOptions > SET IsConfirmed = 1 > WHERE (SELECT BO_BookingDate FROM Bookings WHERE BO_BookingDate != NULL) > > I even tried is not null:-) > > > Senior Coldfusion Developer > Aegeon Pty. Ltd. > www.aegeon.com.au > Phone: +613 8676 4223 > Mobile: 0404 998 273 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2535 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
