Whoops, I wasn't clear. In the db it's a varchar(4000).
That's the weird thing about it. The same values run fine in Toad, can take the same data via the ordinary parts of the applications (the part where is errors is an external XML feed that 'syncs' the data from an external applciation). But something about a series of concurrent updates, throws it wobbly, and assumes I am trying to put long data into a varchar column (which I'm not). The other weird thing is - as long as the string has a few carriage returns in it - it runs fine. Seemingly the 'intelligent' odbc driver realises it must be varchar if it has carriage returns :oP Still no idea on the solution - just praying we get our MX enterprise upgrade sooner rather than later, and we can get off these ODBC drivers. Thanks anyway. Mark ------------------------------------------------------------------ [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [ www.safefrombees.com ] Quoting Stephen Bosworth <[EMAIL PROTECTED]>: > 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
