Replace the = with "IN" in your where clause like so:
update ovdsave
set ovdsave.updatedate = getdate()
where ovdsave.sonum IN (SELECT ovdtemp.SONUM
FROM ovdtemp)
This is because "SELECT ovdtemp.SONUM FROM ovdtemp" returns more than 1
record........
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: 16 May 2001 15:22
To: CF-Talk
Subject: Update Statement
I am tired why is this giving me an error?
update ovdsave
set ovdsave.updatedate = getdate()
where ovdsave.sonum = (SELECT ovdtemp.SONUM
FROM ovdtemp)
and this way also gives me an error:
update ovdsave
set ovdsave.updatedate = getdate()
from (SELECT ovdtemp.SONUM FROM ovdtemp)
where ovdsave.sonum = ovdtemp.sonum
I am running this in a dts package to update ovdsave.updatedate to the
current date if the ovdtemp.sonum = ovdsave.sonum.
Please help so I can go home and sleep.
Joshua Tipton
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
