public void create( faq faq )

CRUD method

Parameters:

faq faq

Code:

	<cffunction name="create" returntype="void" output="false" hint="CRUD method">
		<cfargument name="faq" type="machii_info_sample.model.faq.faq" required="yes" displayname="create" hint="I am the faq from which to create a record" />
		<cfset var faqInsert = 0 />		
		<cfquery name="faqInsert" datasource="#variables.dsn#" >
			SET NOCOUNT ON
			INSERT INTO faqs (
				question,
				answer,
				categoryID,
				createdByUserID
			) VALUES (
				<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#trim(faq.getQuestion())#" >,
				<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#trim(faq.getAnswer())#" >,
				'#trim(arguments.faq.getCategoryID())#',
				<cfqueryparam cfsqltype="CF_SQL_BIGINT" value="#arguments.faq.getCreatedByUserID()#" >
			)
			SELECT @@identity AS faqID
			SET NOCOUNT OFF
		</cfquery>
		<cfset arguments.faq.setFaqID(faqInsert.faqID) />
		<cfreturn />
	</cffunction>