couple of quickies, and i might be able to help - what are the column types you are trying to insert into and what's the nls_language, nls_date_language and n;s_numeric_character set to? cos it looks like you are trying to insert a special char or you haven't enclosed smething in "'s somewhere that you should have.
-----Original Message----- From: Aidan Whitehall [mailto:[EMAIL PROTECTED] Sent: 05 March 2003 16:14 To: [EMAIL PROTECTED] Subject: [ cf-dev ] OT: Invalid character in Oracle Can anyone spot what's causing this error? It's a web form that's been working fine all day up until a few minutes ago, when it started spitting out an invalid character error. The SQL and errors are below. Thanks INSERT INTO land_use( lu_id, ow_owner_id, st_site_id, assessment_date,lu_direction, lu_distance, lu_proximity, lut_id, lu_description) VALUES('0000000996', 'TFE', '5360', {ts '2002-11-20 00:00:00'}, 'e', null, '>5<=50', '12', 'Mile End Lane'); DataSource wizard Detail [MERANT][SequeLink JDBC Driver][ODBC Socket][Oracle][ODBC][Ora]ORA-00911: invalid character ErrorCode HY000 Message Error Executing Database Query. NativeErrorCode 911 -- Aidan Whitehall <[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] Any views or opinions are solely those of the author and do not necessarily represent those of Channel Four Television Corporation unless specifically stated. This email and any files transmitted are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
