Insert Example

<CFSET Active_Flag=1>


<!--- Insert Record --->
<CFLOCK NAME="InsertNewRecord" TYPE="EXCLUSIVE" TIMEOUT="30">
<CFTRANSACTION>
<CFQUERY NAME="AddRecord" datasource="data_source">
INSERT INTO maillist(last_name, first_name, email_address, active_flag)

VALUES('#form.last_name#', '#form.first_name#', '#form.address#', #active_flag#)
</CFQUERY>
</CFTRANSACTION>
</CFLOCK>