Open Source Software and Tools
All of the below are Free and Open Source Software (FOSS) released under the Apache or LGPL Licenses except where noted in the Licenses of derived works. You are free to uses them as you feel fit and incorporate them into open source projects and, license permitting, commercial software.
CF_jscalendar
CF_jscalendar is a ColdFusion wrapper for the DHTML Calendar by Mihai Bazon
It is a very simple way to put a date picker on a form. It uses CFForm for date validation with an option to roll your own JS validation. It has been tested on CF 7-8 and Railo 3.0 and should work on any cf runtime that supports custom tags and CF form.
Download: CF_jscalendar.zip
CFC Generator Lite
CFC Generator Lite is a light weight html front end for Brian Rinaldi's outstanding Illudium PU-36 Code Generatorhttp://code.google.com/p/cfcgenerator/
It is a very paired down version of an application generator I kludged together that is not ready for release. If you are interested in the application generator let me know via a comment on this blog.
The main file, generator.cfc is a very slight modification of the original created by Chris Phillips http://www.cfchris.com/
More information on generator.cfc can be found here
http://www.cfchris.com/cfchris/index.cfm/Database-Abstraction
Download: CodeGenLite.zip
I am merely standing on the shoulders of giants.
CFC's
FileUpload.cfc
This is a simple cfc that uploads, cleans the file of illegal charactors, adds an optional prefix and optionalaly renames the file. It returns a sturct with the sanitize the file name and all the variables returned by: cffile action=upload.
<cfset mypath = GetDirectoryFromPath(GetTemplatePath())>
<cfoutput>
Upload Dir: #mypath#
<form action="#Script_Name#" method="post" enctype="multipart/form-data">
Select File
<br />
<input type="file" name="MyFile">
<br />
<input type="submit" value="Upload File">
</form>
</cfoutput>
<cfif Trim(form.MyFile) NEQ "">
<cfif NOT isdefined("application.FileUpload" )>
<cfset application.FileUpload = createObject("component", "FileUpload").init() >
</cfif>
<cfscript>
ralph = "form.MyFile" ;
ralph = application.FileUpload.upload("form.MyFile", mypath, "Prefix_");
</cfscript>
<!--- application.FileUpload.upload(FileName, "FormFieldName", DesinationDir, uploadResults); --->
<cfdump var="#ralph#">
</cfif>
Download: FileUpload.cfc.zip
mysql.cfc
A re-write of Rob Gonda's SQL.cfc modified to work with MySQL. Requires CfdbInfo
<cfset dsource= "">
<cfset dbuname = "">
<cfset dbpword = "">
<cffunction name="cfdump" returntype="void">
<cfargument name="d">
<cfdump var="#d#">
</cffunction>
<cffunction name="cfparam" returntype="void">
<cfargument name="p">
<cfargument name="d">
<cfparam name="#p#" default="#d#">
</cffunction>
<cfscript>
//StructDelete(application.com,'sql'); cfparam("application.com.sql",createObject('component','sql').init(dsource,dbuname,dbpword));
cfdump(application.com.sql.getSQLSchema('rssfeeds'));
//setup struct f = structNew();
f.TXT_RssFeed_Title = 'teset';
f.RssFeedID = 1;
f.TXT_RssFeed_URL = 'teset';
f.TXT_RssFeed_Discription = 'teset';
f.TXT_RssFeed_WebsiteURL = 'teset';
//update tbl r = application.com.sql.tblUpdate('rssfeeds',f);
//cfdump(r); //insert into tbl r = application.com.sql.tblInsert('rssfeeds',f);
//cfdump(r);
//delete from tbl r = application.com.sql.tblDelete('rssfeeds','RssFeedID = 3');
//cfdump(r); //select from tbl r = application.com.sql.tblSelect('rssfeeds','*','RssFeedID = 1');
//cfdump(r);
//get primary key cfdump(application.com.sql.getPrimaryKey('rssfeeds'));
</cfscript>
Download: mysql.cfc.zip
My (heh.. Award Winning) CFEclipse Snippets
I wrote a script to parse out all of the CF 7 functions and create snippets for CFE. It has all the Varaibles returned by the various ColdFusion Scopes such as
CFError.HTTPReferer
CFFTP.ErrorCode
Client.URLToken
QueryName.ColumnList
I have them orginized much like the Expression Builder did in CF Studio. CFEclipse lists these in the Dictionary view and links to the docs but does not allow you to insert them into your code. Also included are many of the common HTML, JavaScript and ColdFusion elements, as well as CFQuery templates for all the CRUD functions.
Download: snippets.zip
UDFs
ListReturnDuplicates()
Searches a list for case- sensitive Duplicates and returns a list of the duplicate items or zero (0) if no dupes are found.
Usage:
<cfoutput>
List of case-sensitive dupes:
<br />#ListReturnDuplicates(myList)#
</cfoutput>
Download: ListReturnDuplicates.zip
ListReturnDuplicatesNoCase()
Same as above except not case-sensitive
Download: ListReturnDuplicatesNoCase.zip
RSS
