public void create( comment comment )

CRUD method

Parameters:

comment comment

Code:

	<cffunction name="create" returntype="void" output="false" hint="CRUD method">
		<cfargument name="comment" type="machii_info_sample.model.comment.comment" required="yes" displayname="create" hint="I am the comment from which to create a record" />
		<cfset var commentInsert = 0 />				
		<cfquery name="commentInsert" datasource="#variables.dsn#" >
			SET NOCOUNT ON
			INSERT INTO comments (
				comment,
				faqid,
				CreatedByUserID
			) VALUES (				
				<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#trim(arguments.comment.getComment())#" >,	
				<cfqueryparam cfsqltype="CF_SQL_BIGINT" value="#trim(arguments.comment.getFaqID())#" >,
				<cfqueryparam cfsqltype="CF_SQL_BIGINT" value="#trim(arguments.comment.getCreatedByUserID())#" >				
			)
			SELECT @@identity AS commentID
			SET NOCOUNT OFF
		</cfquery>
		<cfset arguments.comment.setCommentID(commentInsert.commentID) >
		<cfreturn />
	</cffunction>