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
