Since I'm using Oracle this sounds like the answer, thanks. Shawn
-----Original Message----- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 3:13 PM To: CF-Talk Subject: RE: ORACLE CLOB, single quotes double quotes turn into question m arks >On the topic of CLOB's. How do you insert it when using <cfqueryparam>? > I've had no trouble using the following with Oracle: <cfqueryparam value="#variable_name#" cfsqltype="CF_SQL_LONGVARCHAR"> Can't speak for other DBMS platforms though. Regards, Dave. _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists