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 />		
		<cfset var qry_lastFaq = 0 />	
		<cfquery name="faqInsert" datasource="#variables.dsn#" >
			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_INTEGER" value="#arguments.faq.getCreatedByUserID()#" >
			)
		</cfquery>
		<cfquery name="qry_lastFaq" datasource="#variables.dsn#" >
			SELECT 	faqID
			FROM	faqs
			WHERE	question = '#trim(arguments.faq.getQuestion())#'
		</cfquery>
		<cfset arguments.faq.setfaqID(qry_lastFaq.faqID) >
		<cfreturn />
	</cffunction>