DataMgr 2.2 Documentation: Replace cfinsert/cfupdate
DataMgr Information
|
| Subscribe to DataMgr |
| Visit this group |
Replace cfinsert/cfupdate
DataMgr can act as a replacement for cfinsert and cfupdate with several advantages.
- It will ignore any form fields that don't have an associated database field.
- It will use an structure you give it (not limited to Form structure)
- It will return the primary key of the inserted or updated record (assuming a simple primary key)
- If a field is too long, error will indicate which field is too long.
<cfif isDefined("Form.employee_id") AND isNumeric(Form.employee_id)>
<cfupdate datasource="#request.dsn#" tablename="employees">
<cfelse>
<cfinsert datasource="#request.dsn#" tablename="employees">
</cfif>
Using DataMgr:
<cfif isDefined("Form.employee_id") AND isNumeric(Form.employee_id)>
<cfset Application.DataMgr.insertRecord("employees",Form)>
<cfelse>
<cfset Application.DataMgr.updateRecord("employees",Form)>
</cfif>
Using DataMgr to automatically determine insert or update action and return primary key:
<cfset employee_id = Application.DataMgr.saveRecord("employees",Form)>