How is the subquery supposed to be connected to the table you are updating? There's nothing relating one to the other in the query...
On 7/31/06, Antony Sideropoulos <[EMAIL PROTECTED]> wrote: > 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:2534 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
