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]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.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
