Rob Gonda's Blog

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 only. This was my first choice because it's used in 85% of ColdFusion applications.

Here are the latest entries related to sqlCFC from my blog:

Copyright 2006 Rob Gonda

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

This blog is running version 5.9.003. Contact Blog Owner