Bryan Anderson dreamstarter

Git

Press minus + shift + s and return to chop/fold long lines!

	<CFSCRIPT>
	myQry = new Query(datasource="cfartgallery"); // new query object
	myQry.setSQL("select bookid, title, genre from app.books where bookid = :bookid"); //set query
	myQry.addParam(name="bookid",value="5",CFSQLTYPE="CF_SQL_INT"); // add query param
	qryRes = myQry.execute(); // execute query
	writedump(qryRes.getResult().recordcount, true); // get resultcount
	writedump(qryRes.getResult(), false); // dump result
	writeoutput('<BR>');
	</CFSCRIPT>

	This will let you log every time a user inserts or updates a record.

	So you can later say:
	Tim performed insert to the "25" record in the Page table via Pages' Edit a few hours ago, etc

	Create a table called Logs with the following columns:
	id int primary autoinc
	userid int
	modelid varchar
	savetype varchar

	<!--- BEGIN: Bootstrap Carousel --->
	<cfset feed=$.getBean('feed').loadBy(name='Your FeedName Goes Here')>
	<cfset iterator=feed.getIterator()>
	<cfif iterator.hasNext()>
	<div id="myCarousel" class="carousel slide">
	<!--- Carousel items --->
	<div class="carousel-inner">
	<cfset idx = 0>
	<cfloop condition="iterator.hasNext()">
	<cfset item=iterator.next()>

	<!--- add the following to the events/onapplicationstart.cfm --->
	<cffunction name="initServices" returntype="void" hint="I initialize the services objects for this app">
	<cfset var loc = {}>
	<cfset application.$_ServiceObjects = {}>
	<cfdirectory action="list" directory="#expandPath('services')#" name="loc.services"/>
	<cfloop query="loc.services">
	<cfset application.$_ServiceObjects[ListFirst(name, '.')] = createObject("component", "services.#ListFirst(name, '.')#").init()>
	</cfloop>
	</cffunction>
	<cfset initServices()>

	<cfscript>
	// NOTE: CFScript added for Gist color-coding only. Remove.

	component
	output="false"
	hint="I define the application settings and event handlers."
	{


	// Define the application settings.

	------------ From Rake Task

	namespace :app do

	# Checks and ensures task is not run in production.
	task :ensure_development_environment => :environment do
	if Rails.env.production?
	raise "\nI'm sorry, I can't do that.\n(You're asking me to drop your production database.)"
	end
	end