RE: ORACLE CLOB, single quotes double quotes turn into question m arks

2002-04-26 Thread Shawn McKee
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

RE: ORACLE CLOB, single quotes double quotes turn into question m arks

2002-04-26 Thread Dave Carabetta
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.

RE: ORACLE CLOB, single quotes double quotes turn into question m arks

2002-04-26 Thread Shawn McKee
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