Skip to content

Instantly share code, notes, and snippets.

@PintuKumarPal
Created August 29, 2013 23:58
Show Gist options
  • Save PintuKumarPal/6384829 to your computer and use it in GitHub Desktop.
Save PintuKumarPal/6384829 to your computer and use it in GitHub Desktop.
<cfcomponent>
<cfset ODBCDataSource="xxxxxxxx">
<cffunction name="UpdateMethod" access="remote" output="false" returnType="string">
<cfquery name="InserRecord" datasource="#ODBCDataSource#">
insert into TableName
(
FirstName,
EmailID,
Qualification,
ContactNo
)
values
(
<cfqueryparam value="#FirstName#" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="#EmailID#" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="#Qualification#" cfsqltype="CF_SQL_VARCHAR">,
<cfqueryparam value="#ContactNo#" cfsqltype="CF_SQL_VARCHAR">
)
</cfquery>
<cfreturn "success">
</cffunction>
</cfcomponent>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment