Managed Hosting



Project Home Forums Known Issues External Project Link Contact Project

Author: Rob Gonda (All RIAForge projects by this author)
Last Updated: October 20, 2006 6:10 AM
Version: 0.2
Views: 21,171
Downloads: 1,413
License: Apache License, Version 2


sqlCFC was developed to facilitate the interaction between CF and SQL. It will also help to abstract the SQL CRUD calls and seamlessly connect to any type of database without changing your CF code or logic.

sqlCFC queries SQL Meta-data, and utilize it to the maximum. It automatically identifies primary keys, identities, data types, field lengths, and adapts accordingly.

All queries are parameterized using cfqueryparams by automatically detecting the field types. By default, the component also trims all strings to the maximum data-type length.

To allow for rapid prototyping, the component can take a structure (form is mostly used) as an argument, cross check common fields with a specific table, and insert or update solely with that information. In case of update, it will also match the primary key, or could optionally take the where clause statement.

sqlCFC is currently compatible with Microsoft SQL Server 2000 and 2005.


ColdFusion MX 6.1+.
Microsoft SQL 2000-2005.

Issue Tracker:

There are no issues for this project.

To enter issues for this (or any other) project, you must be logged in.

Subversion Access:

You may access this project's Subversion repository with your client here: http://svn.riaforge.org/sqlcfc.

To view files and changelists associated with this repository, go here: http://sqlcfc.riaforge.org/index.cfm?event=page.svnbrowse.

Anonymous users have read access to the repository while the administrator has write access.

This project is sharing its code via Subversion. Subversion is an open source source control method. You may find more information about Subversion here: http://subversion.tigris.org/