Hi I am having probs with a CLOB

[ttrinh]

Hi
I am having probs with a CLOB datatype in my CF application.
I have a table with a field called description in it. The database is oracle 8i the description field is a CLOB. I am trying to search using a keyword search on the description field. Everything else in the application works fine except the search function returning an oracle inconsistent datatypes error. So I changed the description dataype to VARCHAR2 .The search function now works but I get runtime errors now which weren't there b4
Error resolving parameter ATTRIBUTES.BINTYPE and
Error while executing cf_binTx:
Attribute "txID" Must be a Numeric Value
I don't understand this at all as I have not altered any code in the application.Also I am getting different runtime errors in the test environment and production environment. Both the test and production applications point to the same production database though.I altered the database via SQLPlus.
I did not write the origninal application but I think the txID is an attribute in the custom tag BinTx

Any help is greatly appreciated

 

[tleish]

What version of ColdFusion are you running?

ColdFusion Server 4.5.1 SP2 Release Notes
Enhancements and new features in SP2
See the following for details about enhancements added in ColdFusion Server 4.5.1 SP2:

CLOB Support for Oracle 8
The Oracle 8 native driver now supports inserting and updating CLOB columns with INSERT, UPDATE, and SELECT statements.

- tleish

 

[ttrinh]

Hi
I am running CF server 4.5 and oracle 8.1.7
Where do I go for release details of the software I 'm using ? But I still don't get why a change in a table (column datatype change ) would generate errors like that when I have not altered any application code

 

[ttrinh]

I have now changed the database table column back to CLOB datatype but I am still getting the same errors as before
Error while executing cf_binTx:
Attribute "txID" Must be a Numeric Value

I have read up on how to manipulate CLOBs in Oracle 8i .However I think the problem may be coming from the Cold Fusion side. I don't understand how CF custom tags work . I think the attribute "txID" comes from a file called binTx.cfm. I don't know what exactly this file does but it has a whole lot of error checking statements checking ie
if (NOT isNumeric(attributes.txID)) {
// Error Found! Get outta my tag
foundErr="true";
errStr = &quot;#errStr# <LI>Attribute &quot;&quot;txID&quot;&quot; Must be a Numeric Value&quot;;

Any ideas?

 

[ttrinh]

I have found out what the problem is.When I made a copy of the table I did not copy all the default values set on it and hence the error.