I am trying to improve my code and working more with cfqueryparam. I wrote this
query as an example using as many elements of cfqueryparam as I could think of.
Most of it based on examples from CFtalk. I was hoping someone proficient with
cfqueryparam could take a look and make suggestions. Code is for MS Access:
<cfquery name="insNewRecord" datasource="#DSN#">
INSERT INTO Database (Active, Contributed, DateAdded, AddedBy, UUID
, ParentRecord, PageReference, RecordName, RecordText, ImageFile
, DateTaken, TakenBy, PlaceTaken, ProjectReference)
VALUES (<cfqueryparam cfsqltype="cf_sql_integer" value="#FORM.Active#"/>
, <cfqueryparam cfsqltype="cf_sql_integer"
value="#Trim(FORM.Contributed)#" null="#IIF(Trim(FORM.Contributed) EQ '', true,
false)#">
, <cfqueryparam cfsqltype="cf_sql_date"
value="#CreateODBCDateTime(Now())#"/>
, <cfqueryparam cfsqltype="cf_sql_varchar"
value="#getUser.EmailAddress#"/>
, <cfqueryparam cfsqltype="cf_sql_varchar" value="#Trim(FORM.UUID)#"
maxlength="255"/>
, <cfqueryparam cfsqltype="cf_sql_integer"
value="#Trim(FORM.ParentRecord)#">
, <cfqueryparam cfsqltype="cf_sql_integer"
value="#Trim(FORM.PageReference)#">
, <cfqueryparam cfsqltype="cf_sql_varchar"
value="#Trim(FORM.RecordName)#" maxlength="255"/>
, <cfqueryparam cfsqltype="cf_sql_clob"
value="#Trim(FORM.RecordText)#"/>
, <cfqueryparam cfsqltype="cf_sql_varchar"
value="#Trim(FORM.ImageFile)#" maxlength="255"/>
, <cfqueryparam cfsqltype="cf_sql_date" value="#Trim(FORM.DateTaken)#"
null="#IIF(Trim(FORM.DateTaken) EQ '', true, false)#">
, <cfqueryparam cfsqltype="cf_sql_varchar" value="#Trim(FORM.TakenBy)#"
null="#IIF(Trim(FORM.TakenBy) EQ '', true, false)#" maxlength="255">
, <cfqueryparam cfsqltype="cf_sql_varchar"
value="#Trim(FORM.PlaceTaken)#" null="#IIF(Trim(FORM.PlaceTaken) EQ '', true,
false)#" maxlength="255">
, <cfqueryparam cfsqltype="cf_sql_integer"
value="#Trim(URL.ProjectID)#">)
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5141
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
