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

Reply via email to