Mark, In your DB schema, is the column a LONG, CLOB or varchar?
Some things to try: If the filed is a LONG or CLOB in the DB, use <cfqueryparam value="#value#" cfsqltype="CF_SQL_LONGVARCHAR"> If varchar, use <cfqueryparam value="#value#" cfsqltype="CF_SQL_VARCHAR"> Also, check your long settings in the administrator, and set the long text value to a value that suits (default is 65000 characters). HTH, Steve -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Stephen Bosworth Application Development and Integration Communication and Information Services The University of Newcastle, Australia Phone: 02 4921 6574 Fax: 02 4921 7087 Email: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>> [EMAIL PROTECTED] 21/11/2003 10:59:02 am >>> Hey all - Got CFMX Pro and Oracle 9i. (Hooked in via 9i ODBC drivers) Anyone else got / seen this problem? I've got some dynamically generated SQL updates happening, and I keep catching this error: ORA-01461: can bind a LONG value only for insert into a LONG column When I've got it set as <cfqueryparam value="#value#" cfsqltype="CF_SQL_VARCHAR"> So I don't know why it thinks I'm binding it as a LONG. It's driving me banannas. If i take out the cfqueryparam, I get that the query comes out too long - as some string can be up to 3000/4000 characters long. Any help would be appreciated. Mark ------------------------------------------------------------------ [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [ www.safefrombees.com ] --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
