Regular selects should work just fine.
I also have the 'Enable retrieval of long text' checked in CF administrator.
HTH
P.
-----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
