0

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?!?
:o

Jam

1
Contributor
1
Reply
2
Views
12 Years
Discussion Span
Last Post by jamba
0

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

Jam

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.