INSERT Statement - ColdFusion

Submitted by:Andery Smith

Date added:20 June, 2011

Category:ColdFusion

A simple INSERT statement in MSSQL with the various types of values.

Tags: insert statement

Code Snippet:

<cfquery name="INSERTCustomer" datasource="#APPLICATION.DSN#">
INSERT INTO TableName
(
Fieldname1,
Fieldname2,
Fieldname3
)
VALUES
(
'#trim(StringValue)#',
#NumericValue#,
#createodbcdate(now())# <!--- Properly formated date --->
)
</cfquery>
 
 

Comments