Member Avatar for jamba

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
  • 68 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by jamba
Member Avatar for 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...

Jam

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.