That will set everything on a given date, not individually confirmed bookings. Joining by the common BO_ID is necessary.
On 7/31/06, Antony Sideropoulos <[EMAIL PROTECTED]> wrote: > 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:2538 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
