Are these executing in one cfquery block? If so, do you need a command
separator between the statements (mysql uses ";" for example)?
Mark
-----Original Message-----
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 13, 2007 12:35 PM
To: CF-Talk
Subject: Can anybody see why the first SQL statement works but the
second throws an error.
UPDATE INTRANET.TRAK_CMP
SET
LOC_CODE = 'ROSE',
CMP_CD = '018251',
SCAN_DATE = {ts '2007-06-13 00:00:00'}
WHERE
USER_ID = 'iskinner' AND
ENTRY_DATE = {ts '2007-06-13 09:28:58'} AND
UNIT_NO = 'FN09427' AND
CMP_CD = '018250'
UPDATE INTRANET.TRAK_CMP
SET
LOC_CODE = 'ROSE',
CMP_CD = 'E03360',
SCAN_DATE = {ts '2007-06-13 00:00:00'}
WHERE
USER_ID = 'iskinner' AND
ENTRY_DATE = {ts '2007-06-13 09:03:43'} AND
UNIT_NO = 'W115905000001' AND
CMP_CD = 'E0929W'
The second statement throws this error: "[Macromedia][Oracle JDBC
Driver][Oracle]ORA-00942: table or view does not exist" but as the first
statement works just fine, I must assume that some other issue is at
play here.
Confidentiality Notice: This message including any attachments is for
the sole use of the intended
recipient(s) and may contain confidential and privileged information.
Any unauthorized review, use, disclosure or distribution is prohibited.
If you are not the intended recipient, please contact the sender and
delete any copies of this message.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
CF 8 â Scorpio beta now available,
easily build great internet experiences â Try it now on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281057
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
