Project Home • Forums • Known Issues • External Project Link • Contact Project
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.
There are no issues for this project.
To enter issues for this (or any other) project, you must be logged in.
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/
Adobe and the Adobe product names are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States and/or other countries.