Thanks! That looks good.
Do you figure this will work with client variables and writing right to the CDATA
table? Or would it be best to use a different table and not use CF's client variables?
I ask because if I manually write a variable to the CDATA table, then I wonder if CF
would just write over it when it saves all the client variables at the end of the page
request.
thanks,
Chris Norloff
-- Original Message --
from: Deanna Schneider [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Tue, 25 Sep 2001 12:58:35 -0500
I believe that you just have to use a cfprocparam ... tag to insert long
or clob data into oracle - something like
cfquery name=insert datasource=#dsn# username=#uname#
password=#pword#
INSERT INTO longtest(clientvars)
VALUES(cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR
value=#cfclientvariables#)
/cfquery
cfclientvariables would be the variable name of the client variables you are
inserting. I just tried this on our setup and it worked great.
-Deanna
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
~~
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
