We had the same issue with getting gibberish.
What we found was that if you insert a record into a table with a clob, you
need to set the value of the clob on insert, even if its an empty string.
If you insert a record without including a value for the clob, your select
against that row will seem to draw data from the fourth dimension.
We're using clobs with native drivers all the time.
-----Original Message-----
From: Rosa, Issac [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 10:16 AM
To: CF-Talk
Subject: RE: Question about retrieving Oracle CLOBs into a CF variable
You should be able to just do select clob_column from table [where]. We had
a problems using clob and retrieving erroneous data or gibberish. Not sure
if it was related to Native drivers or what the issue was exactly. So we
changed to Long datatype and everything works great. Good luck. LOL
Issac Rosa
IT - National Sales & Marketing
Web Developer
Ofc: 407-658-3111
Cell: 407-342-0644
Fax: 407-971-2374
[EMAIL PROTECTED]
-----Original Message-----
From: Tim Dempsey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 11:02 PM
To: CF-Talk
Subject: Question about retrieving Oracle CLOBs into a CF variable
Folks,
In one CF template I insert a very long string (e.g. >10000 bytes) into a
CLOB column of a new row in an Oracle table. (Actually the CLOB is the
string resulting from a CFWDDX tage that converts a CF structure of
structures to a string.).
I do this insert by using the CFQUERYPARAM tag to force CF to generate a
bind variable like Oracle wants for CLOBs.
Now, in another CF template I need to retrieve it. My question is, how????
Can I simply say "select clob_column from table where<condition is true>"?
Can I then refer to QueryName.clob_column and get the whole humoungous
string? Or do I need to force CF to use bind variables again? If so how do I
do that in a select statement? Can I say "select clob_column into
<cfqueryparam value="#local_cf_variable#"> from table where <condition is
true>???? Does that work?
Can anyone advise? I will be most appreciative of any help.
Thanks,
-- Tim Dempsey
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
