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? Shawn McKee Manager, Web Development NewsStand, Inc. 8620 Burnet Rd., Suite 100 Austin, TX 78757 USA 512-334-5100 Read newspapers and magazines from around the world in a whole new way. NewsStand delivers them to your PC without paper and without delay! Try: http://www.newsstand.com?NSEMC=EMNSI01 __ Get the mailserver that powers this list at http://www.coolfusion.com 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
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. __ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ORACLE CLOB, single quotes double quotes turn into question m arks
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