The Ramblings of a ColdFusion junkie

ColdFusion Developer Telecommute - Part-Time

2010-05-06T11:05:04Z

ColdFusion Developer - Part-Time Company: Event Ready http://www.eventready.com/erSite/ Location: Telecommute is ok Position(s): Part-Time or Internship Hours: Flexible Hours M-F, 8:00 a.m. to 5:00 p.m. Min-Requirements: 1 to 3 years ColdFusion Experience The position requires 9-12 hours per week (M-F 8:30 a.m. to 5:00 p.m.). Some flexibility on hours/days based on needs. This position may turn into a fulltime position. Please send your resume by email to matt [at] eventready.com. Position open until filled. Start date: ASAP.

Birthday is coming up

2010-04-01T01:04:03Z

My Birthday is just around the corner so if anyone would like to to donate to my Birthday fund.

RegEx Help

2009-10-29T03:10:56Z

I need a RegEx to get all of the html between .

Looking for Membship App.

2009-10-27T03:10:36Z

I am looking for an open source/free membership application written in ColdFusion. If anyone know of please let me know.

Google Wave Invites

2009-10-27T03:10:13Z

Update they're all gone.

I have Google wave invites. If you would like one please respond and I'll hand them first come first serve.

JAVA UUID using ColdFusion

2009-10-14T03:10:21Z

This is just a note to myself

Using WDDX as a Datasource

2009-09-17T02:09:19Z

I did some work for a friend a couple of months ago and he needed me create an XML document to house student information never more than 10 students. So I thought simple of I’ll just create a simple XML Doc and loop through it. And then I remembered that I wasn’t that fond working with XML. So I decided to create a ColdFusion and store it in memory.

I know that wasn’t a good, so I decided to create a ColdFusion query and then turn it into WDDX format then save it to a file.

Now I can just read the file and query and do all the CRUD operations against it the recordset. So now I had the problem how to update the data and what if they want to move to a real DB. Well this is what I did, I created a couple of CFC’s one of which is a base WDDXDAO which has these functions

getWDDXRS This function reads my WDDX xml file and returns a ColdFusion Query

saveWDDXRS This function saves my ColddFusion query into WDDX format

Now I can write my studentDAO which extends wddxDAO here is the init function you’ll notice that it is expecting an argument of dbfile, that is the absolute path to the WDDX file. Also in the init function you’ll notice that I am checking to see if the file exists and if it does I call the saveWDDXRS function from my WDDXDAO.

Next function is getRS this function is really for my Gateway you will see that later.

Create function this function create a new record in our WDDX RS, first we get the query from the WDDXDAO and then we add a new record to it and then save the file.

read function will simply open the WDDX file again and query the RS for the studentID that the user is looking for.

update function here I open the WDDX file and do a listFindNoCase to get the current row number to update.

delete function here I open the WDDX file then query the RS for everything that is not equal to the current studentID and then save that RS.

Exists function this function checks to see if a record exists or not.

save here we call our Exists function and if a record does exists we call the update function and if doesn’t we call the create function.

Here is my my student bean it has one method and extends my base Bean CFC.

Here is my base bean CFC

Here is my gateway CFC.

<cfset variables.studentDAO = arguments.studentDAO />
	
		<cfreturn this />
	</cffunction>
	
	<cffunction name="getByAttributesQuery" access="public" output="false" returntype="query">
		<cfargument name="studentID" type="string" required="false" default="" />
		<cfargument name="StudentName" type="string" required="false" default="" />
		<cfargument name="Major" type="string" required="false" default="" />
		<cfargument name="GradeAvg" type="string" required="false" default="" />
		<cfargument name="Gender" type="string" required="false" default="" />
		
		<cfset var qList = variables.studentDAO.getRS(true) />
		
		<cfquery name="qList" dbtype="query">
			SELECT 	*
			FROM	qList
			WHERE	0=0
		
		<cfif structKeyExists(arguments,"studentID") and len(arguments.studentID)>
			AND	LOWER(studentID) = <cfqueryparam value="#lcase(arguments.studentID)#" CFSQLType="cf_sql_varchar" />
		</cfif>
		<cfif structKeyExists(arguments,"StudentName") and len(arguments.StudentName)>
			AND	LOWER(StudentName) = <cfqueryparam value="#lcase(arguments.Client_Name)#" CFSQLType="cf_sql_varchar" />
		</cfif>
		<cfif structKeyExists(arguments,"Major") and len(arguments.Major)>
			AND	LOWER(Major) = <cfqueryparam value="#lcase(arguments.Major)#" CFSQLType="cf_sql_varchar" />
		</cfif>
		<cfif structKeyExists(arguments,"GradeAvg") and len(arguments.GradeAvg)>
			AND	GradeAvg = <cfqueryparam value="#arguments.GradeAvg#" CFSQLType="cf_sql_integer" />
		</cfif>
		<cfif structKeyExists(arguments,"Gender") and len(arguments.Gender)>
			AND	LOWER(Gender) = <cfqueryparam value="#lcase(arguments.Gender)#" CFSQLType="cf_sql_varchar" />
		</cfif>
		<cfif structKeyExists(arguments, "orderby") and len(arguments.orderBy)>
			ORDER BY #arguments.orderby#
		</cfif>
		</cfquery>
		
		<cfreturn qList />
	</cffunction>

Now I know this seems to be a bit much for a small website and for 10 students but think in terms of scalability. Now if he comes back to me and says I need to migrate to SQL Server or MySQL all I need to do is create a new Gateway and DAO.

I would love to hear any and all thoughts on this.

Communicating with Developers

2009-08-17T09:08:48Z

How To Effectively Communicate With Developers

'"If you have ever worked with a developer or a development team, this article will probably strike close to home. As designers, we work with dozens of developers across the globe each year. Some of us are fortunate enough to find a gem; a developer that just gets it. A developer that you feel is on your same wavelength in terms of what needs to be accomplished with the user interface, and what it needs to happen. Most often, however, we find developers that we generally don’t see eye to eye with."

CSS + jQuery Menu

2009-07-28T08:07:15Z

First the jQuery Second the CSS last the HTML

Regular expressions syntax note

2009-07-28T02:07:32Z

Regular Expression	Will match...
CF	The string "CF"
^CF	"CF" at the start of a string
CF$	"CF" at the end of a string
^CF$	"CF" when it is alone on a string
[abc]	a, b, or c
[a-z]	Any lowercase letter
[^A-Z]	Any character that is not a uppercase letter
(gif\|jpg)	Matches either "gif" or "jpeg"
[a-z]+	One or more lowercase letters
[0-9.-]	?ny number, dot, or minus sign
^[a-zA-Z0-9_]{1,}$	Any word of at least one letter, number or _
([wx])([yz])	wy, wz, xy, or xz
[^A-Za-z0-9]	Any symbol (not a number or a letter)
([A-Z]{3}\|[0-9]{4})	Matches three letters or four numbers

Employee begs for Firefox

2009-07-16T01:07:06Z

Not sure what to say about this.
State Dept. to Clinton: Please let us use Firefox

New UDF (makeDistinctList)

2009-07-16T10:07:20Z

Quick and dirty UDF. I needed to make a list just have distinct values for logging purposes so I wrote a little UDF. Here it is

Update
After reading Adrian J. Moreno and doing some CFTimer testing I found that the code below night and day faster.

How To Design A Good API and Why it Matters by Google

2009-07-14T02:07:25Z

Links or my reference

2009-07-12T10:07:26Z

Easy Tooltip - jQuery plugin

http://jakeapp.com/

http://xrefresh.binaryage.com/

UML

http://www.horstmann.com/violet/

http://www.gliffy.com/

Design patterns

http://www.oodesign.com/

PDF Quick Reference

I downloaded the original document from here http://www.mcdonaldland.info/2007/11/28/40/

A Full Featured CSS Framework: BlueTrip

2009-06-26T10:06:00Z

I can across this really nice CSS framework.

What Can BlueTrip Do For You?

BlueTrip gives you a sensible set of styles and a common way to build a website so that you can skip past the grunt work and get right to designing.

Download the package, include the images and stylesheets in your site structure, and get going!

Features List:

24-column grid
Sensible typography styles
Clean form styles
A print stylesheet
An empty starter stylesheet
Sexy buttons
Status message styles

Demos