hmm didn't get the original reply, how odd... yup, drop the quotes from the number field...but then all other entries should fail with that too. nls params are available if you query select * from v$nls_parameters; as a user with sysdba privs ;
-----Original Message----- From: Stephen Fernandez [mailto:[EMAIL PROTECTED] Sent: 05 March 2003 17:34 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] OT: Invalid character in Oracle lut_id is a number field but when u are submitting the value to go in that field you have it inside quotes, you should only have text strings in quotes, values that are number datatypes should be submitted without quotes around them ----- Original Message ----- From: "Aidan Whitehall" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 05, 2003 4:44 PM Subject: RE: [ cf-dev ] OT: Invalid character in Oracle > what are the column types > you are trying to insert into <pre> NAME DATATYPE SIZE SCALE NULL? lu_id varchar2 10 ow_owner_id varchar2 10 st_site_id varchar2 10 assessment_date date lu_direction varchar2 3 lu_distance number 10 2 null lu_proximity varchar2 10 null lut_id number 10 0 lu_description varchar2 50 null </pre> > what's the nls_language, nls_date_language > and n;s_numeric_character set to? I don't honestly know. Is that something I can find out from Enterprise Manager? > 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. Well, eye-balling the SQL looks fine, but guess that wouldn't reveal high characters. However, the text entered is strictly letters and spaces, no apostrophies, high characters, etc. Entering other records for the same owner / site / date works fine until you try to add a record with an lu_description. And yet entering lu_description values for other sites have been working fine. Weird. Thanks for your time, btw. -- 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] --- Outgoing mail is certified is certified Drug, Virus and Religion Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 25/02/2003 -- ** 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]
