Login

    Register

This is to notify all, that we will be decommissioning http://riaforge.org/ ("Site") soon. This decision has been taken due to business reasons. If you are interested in reviewing or downloading any project or files available at Site, please do so, by April 16, 2019, 12 noon PST , as per license terms associated therewith. Past that, you will not be able to access the projects or files.Should you have any concerns/suggestions/query, feel free to Contact Us.
Managed Hosting

PROJECT CATEGORIES

 

sqlCFC
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,332
Downloads: 1,418
License: Apache License, Version 2

Description:

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.

Requirements:

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/


This is to notify all, that we will be decommissioning http://riaforge.org/ ("Site") soon. This decision has been taken due to business reasons. If you are interested in reviewing or downloading any project or files available at Site, please do so, by April 16, 2019, 12 noon PST , as per license terms associated therewith. Past that, you will not be able to access the projects or files.Should you have any concerns/suggestions/query, feel free to Contact Us.