Elements plural. Something like:
UPDATE myschema.BookInventory
SET myschema.Status = 'Checked Out',
myschema.CheckedTo = 'rayb',
myschema.ChgDate = {ts '2003-09-16 16:08:22'}
WHERE myschema.id = 2043
CC
----------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use of
e-mail for such purpose.
----------------------------------------------------------------------------------------
Casey C Cook/ASD/CSC
@CSC
09/16/2003 04:56 PM
Please respond to cf-talk
To: CF-Talk <[EMAIL PROTECTED]>
cc:
Subject: RE: Date problem with CFMX and Oracle
Try prefixing your query element with the schema name.
CC
----------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use of
e-mail for such purpose.
----------------------------------------------------------------------------------------
"Ray Bujarski" <rayb
@qualcomm.com>
09/16/2003 04:19 PM
Please respond to cf-talk
To: CF-Talk <[EMAIL PROTECTED]>
cc:
Subject: RE: Date problem with CFMX and Oracle
As mentioned before, I never had a problem b4 I upgraded. But also, my
editor doesn't highlight it as it does other reserved words.
-----Original Message-----
From: Angel Stewart [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 4:17 PM
To: CF-Talk
Subject: RE: Date problem with CFMX and Oracle
Mm..is Status a reserved word?
-Gel
-----Original Message-----
From: Ray Bujarski [mailto:[EMAIL PROTECTED]
I am trying to do an update to my DB:
UPDATE BookInventory
SET Status = 'Checked Out',
CheckedTo = 'rayb',
ChgDate = {ts '2003-09-16 16:08:22'}
WHERE id = 2043
This worked fine before, I updated my CFMX server to 6.01 and my JDBC
drivers to 1.4, and am now getting column doesn't exist! Does anyone
know why this no longer works?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
