public void create( userTO userData )

CRUD method

Parameters:

userTO userData

Code:

	<cffunction name="create" returntype="void" output="false" hint="CRUD method">
		<cfargument name="userData" type="machii_info_sample.model.user.userTO" required="yes" displayname="User" hint="I am the user from which to create a record" />		
		<cfset var userInsert = 0 >				
		<cfquery name="userInsert" datasource="#variables.dsn#" >
			SET NOCOUNT ON
			INSERT INTO users (
				username,
				password,
				lastName,
				firstName,
				email,
				company,
				isAdmin,
				dateCreated
			) VALUES (
				'#left(trim(arguments.userData.username),15)#',
				'#left(trim(arguments.userData.password),15)#',
				'#left(trim(arguments.userData.lastName),25)#',
				'#left(trim(arguments.userData.firstName),25)#',
				'#left(trim(arguments.userData.email),50)#',
				'#left(trim(arguments.userData.company),25)#',
				<cfqueryparam cfsqltype="CF_SQL_BIGINT" value="#arguments.userData.isAdmin#" >,
				getDate()
			)
			SELECT @@identity AS userID
			SET NOCOUNT OFF
		</cfquery>
	</cffunction>