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
