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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281053
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
