For reference, here is my user.cfc thus far:
<cfcomponent>
<cffunction name="insertUser" access="public" returntype="query"
hint="accepts data for new user and returns a structure with status
success or failure">
<!--- Required Arguments --->
<cfargument name="userID" type="numeric" required="yes">
<cfargument name="userRole_ID" type="numeric" required="yes">
<cfargument name="userMailingList_ID" type="numeric"
required="yes">
<cfargument name="userFirstName" type="string" required="yes">
<cfargument name="userLastName" type="string" required="yes">
<cfargument name="userEmail" type="string" required="yes">
<cfargument name="userPassword" type="string" required="yes">
<!--- Optional Arguments --->
<!--- Creatw structure to return results --->
<cfset insertUser = structNew()>
<cfset insertUser.status = "success">
<cftry>
<!--- combine the insert query and the select query --->
<cftransaction>
<cfquery name="rsInsertUser"
datasource="#application.dsn#">
INSERT INTO users(
userRole_ID,
userFirstName,
userLastName,
userEmail,
userPassword)
VALUES(
"#arguments.userRole_ID#",
"#arguments.userFirstName#",
"#arguments.userLastName#",
"#arguments.userEmail#",
"#arguments.userPassword#",
"#arguments.userMailingList_ID#")
</cfquery>
<cfquery name="rsNewUser"
datasource="#application.dsn#">
SELECT MAX(userID) as new_userID
FROM users
WHERE userEmail = #arguments.userEmail#
</cfquery>
</cftransaction>
<cfcatch type="any">
<cfset insertUser.status = "failure">
<cfset insertuser.userID = 0>
</cfcatch>
</cftry>
<cfreturn rsInsertUser>
</cffunction>
</cfcomponent>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231975
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
