> 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]
