DELETE Statement - ColdFusion

Submitted by:Andery Smith

Date added:20 June, 2011

Category:ColdFusion

A simple DELETE statement in MSSQL

Tags: delete statement

Code Snippet:


<cfquery name="DELETECustomer" datasource="#APPLICATION.DSN#">
DELETE FROM TableName
WHERE FieldName4 = <cfqueryparam value = "#query.ID#"
cfsqltype = "cf_sql_integer">
</cfquery>
<!--- ALWAYS remember your WHERE statement! --->
 
 

Comments