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 />		
		<cfset var qry_lastUser = 0 />
		<cfquery name="userInsert" datasource="#variables.dsn#" >			
			INSERT INTO users (
				username,
				password,
				lastName,
				firstName,
				email,
				company,
				isAdmin,
				dateCreated
			) VALUES (
				'#left(trim(userData.username),15)#',
				'#left(trim(userData.password),15)#',
				'#left(trim(userData.lastName),25)#',
				'#left(trim(userData.firstName),25)#',
				'#left(trim(userData.email),50)#',
				'#left(trim(userData.company),25)#',
				<cfqueryparam cfsqltype="CF_SQL_BIGINT" value="#userData.isAdmin#" >,
				now()
			)			
		</cfquery>
		<cfquery name="qry_lastUser" datasource="#variables.dsn#" >
			SELECT 	userID
			FROM	users
			WHERE	username = '#left(trim(userData.username),15)#'
		</cfquery>
		<cfset arguments.user.setuserID(qry_lastUser.userID) >
		<cfreturn />
	</cffunction>