Try: UPDATE BookingOptions SET IsConfirmed = 1 WHERE BookingDate in (SELECT BO_BookingDate FROM Bookings WHERE BO_BookingDate != NULL)
Remember, your select is returning a list of dates that need to match up with dates in the BookingOptions table. On 7/31/06, Andrew Scott <[EMAIL PROTECTED]> wrote: > > 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:2536 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
