update oracle column but bot replace

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ColdFusion section within the Web Development category of DaniWeb, a massive community of 373,538 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,805 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ColdFusion advertiser:

Thread Tools Display Modes

Views: 6920 | Replies: 1

•

Join Date: Oct 2005

Posts: 8

Reputation: jamba is an unknown quantity at this point

Rep Power: 0

Solved Threads: 1

jamba

Offline

Newbie Poster

update oracle column but bot replace

Oct 7th, 2005

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

•

Join Date: Oct 2005

Posts: 8

Reputation: jamba is an unknown quantity at this point

Rep Power: 0

Solved Threads: 1

jamba

Offline

Newbie Poster

Re: update oracle column but bot replace

Oct 17th, 2005

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