Try removing the terminal ";" -----Original Message----- From: Jennifer [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 11, 2000 5:34 PM To: [EMAIL PROTECTED] Subject: OT: Oracle native drivers PS I'm a flake today blah blah. So, here's the problem. They finally decided to switch over to the native Oracle drivers and now the SQL select statements are hosed. The This is the error that I'm getting: Oracle Error Code = 911 ORA-00911: invalid character SQL = "SELECT EVENTID, EVENTNAME, EVENTDESCRIPTION, EVENTSTARTTIME, EVENTENDTIME, EVENTTIMEOUT, TO_CHAR(TRUNC(EVENTSTARTDATE), 'DD-Mon-YY') AS EVENTSTARTTIMEFORMATTED, EVENTENDDATE FROM TBLEVENTS WHERE TO_CHAR(TRUNC(EVENTSTARTDATE), 'DD-Mon-YY') = '11-May-00' AND EVENTTIMEOUT > '04:23 PM' AND EXHIBITION <>1 ORDER BY EVENTSTARTTIMEFORMATTED;" I've tried taking out the TO_CHAR but then I get Oracle Error Code = 920, invalid relational operator. I've also tried changing the <> to != and I still get the invalid character error. I've also also tried using and ODBC value for EVENTTIMEOUT. Invalid character error. They just set up new tables, so this may be a database problem. If no one can find an error in the code, that's probably what the problem is. But if anyone with more Oracle experience than I have sees something glaringly obvious that Oracle native drivers don't like, please let me know. I will assume that lack of response means that no one sees anything wrong. I'm not getting informative error messages even though I'm added to the debugger. ---------------------------------------------------------------------------- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
