Go Back   CodingForums.com > :: Server side development > MySQL > Other Databases

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 12-05-2012, 03:27 PM   PM User | #1
WolfShade
Regular Coder

 
Join Date: Apr 2012
Location: St. Louis, MO, USA
Posts: 952
Thanks: 7
Thanked 98 Times in 98 Posts
WolfShade is an unknown quantity at this point
Question ORACLE: invalid SQL statement

Hello, everyone.

I'm trying to update one column in one table, and I'm getting an "invalid SQL statement" error message from the Oracle database. Could someone please tell me what I'm doing incorrectly?

Code:
UPDATE [schema].[table]
SET status = 'Working'
WHERE create_date = '2012-12-05 08:50:55'
I've tried this with and without TRUNC() and to_Date().

UPDATE: I had code remarked with /* and */ in front of the query. I thought it would be ignored, but apparently it was enough to make the db server think that there was invalid SQL present.

Thanks,
__________________
^_^

If anyone knows of a website that can offer ColdFusion help that isn't controlled by neurotic, pedantic jerks* (stackoverflow.com), please PM me with a link.
*
The neurotic, pedantic jerks are not the owners; just the people who are in control of the "popularity contest".

Last edited by WolfShade; 12-05-2012 at 04:32 PM..
WolfShade is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 12:27 AM.


Advertisement
Log in to turn off these ads.