Hi Folks!
Wonder if you can help??
I need to know a way of updating a column in Oracle (datatype: long) but keep the existing data so like an append. Am using Coldfusion to write to Oracle and I know that you can only write 4000 chars at a time, but not sure how you add to what's already there without having to break the 4000 char limit...

Hope this makes sense?!?


12 Years
Discussion Span
Last Post by jamba

OK - I figured it out. You cannot perform a where/like query on an ORACLE long datatype as it expects an integer. I changed the datatype to a CLOB and then retrieved the field into a temp var. I then added the user input to the temp var and finally updated the record by use of cfqueryparam:

UPDATE theTable SET theColumn = <cfqueryparam value="#tempVar#" cfsqltype="CF_SQL_LONGVARCHAR"> WHERE theTableID = theTableIDValue

..equally I can now perform a search on the CLOB datatype:

SELECT theColumn FROM theTable WHERE theColumn LIKE <cfqueryparam value="%#tempVar#%" cfsqltype="CF_SQL_LONGVARCHAR">

I award myself 100 bonus points...


This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.