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
