One example would be this query (just guessing at your datatypes, which need to
match the columns in the database):
> <CFQUERY DATASOURCE="#arguments.dsn#">
> INSERT INTO SC_Trac_Results
> (TR_ResultCode,
> TR_CustParams,
> TR_Date)
> VALUES
> (
<cfqueryparam cfsqltype="CF_SQL_INTEGER"
value="#return_trac_result#">,
> <cfqueryparam cfsqltype="CF_SQL_VARCHAR"
> value="#CustParams#">,
> <cfqueryparam cfsqltype="CF_SQL_DATE"
> value="#trim(form.CreateDate)#">
)
> </CFQUERY>
Note that you don't use the ' inside the value parameter, just the value and
then let the cfsqltype dictate how the data connection handles it.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314864
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
