CFLib.org – Common Function Library Project

DatabaseLib

Last updated March 6, 2010 / 20 Released UDF(s)
Download Library
cfStoredProcSearch

Search SQL Server Stored Procedures for a value. | Requires: ColdFusion MX

View UDF
Loading...
exportSQLTable

Export table data in script format (INSERT statements). | Requires: ColdFusion MX7

View UDF
Loading...
GetDB2TimeStamp

Takes a ColdFusion date object and returns a DB2 formatted timestamp. | Requires: ColdFusion 5

View UDF
Loading...
GetDSNs

Gets a list of DSNs. | Requires: ColdFusion MX

View UDF
Loading...
getGeneratedKey

Normalizes the various possible returned keys in the cfquery result struct. | Requires: ColdFusion 8

View UDF
Loading...
IsSQLInject

Tests a string, one-dimensional array, or simple struct for possible SQL injection. | Requires: ColdFusion 5

View UDF
Loading...
limit

Mimics MySQL limit's function. | Requires: ColdFusion MX

View UDF
Loading...
MSSQL2CFSQLDT

Convert Microsoft SQL Server Data Type to equivilent CFSQLType | Requires: ColdFusion MX

View UDF
Loading...
MSSQLCreateUUID

Creates UUIDs safe for use in MSSQL UNIQUEIDENTIFIER fields. | Requires: ColdFusion 5

View UDF
Loading...
MSSQLInt

Checks to see if the number is a valid SQL-92 integer. | Requires: ColdFusion 5

View UDF
Loading...
MySQLDT2TS

Converts a CF DateTime object into a MySQL timestamp. | Requires: ColdFusion 5

View UDF
Loading...
MySQLTS2DT

Converts a MySQL timestamp to a CF DateTime object. | Requires: ColdFusion 5

View UDF
Loading...
NullColumn

Useful in constructing SQL statements that must handle empty strings as NULLs. | Requires: ColdFusion 5

View UDF
Loading...
qryOrderToTable

Change query order from horizontal to vertical to display in a HTML table | Requires: ColdFusion 5

View UDF
Loading...
QueryGetSQL

Returns the SQL statement used to generate the specified query. | Requires: ColdFusion MX

View UDF
Loading...
removeSQLStops

Removes ms sql freetext stop words from a sting. | Requires: ColdFusion 5

View UDF
Loading...
showDatabaseTablesMySQL

This function will return all child tables of a mySQL database as an array. | Requires: ColdFusion MX

View UDF
Loading...
smartSearch

Smart boolean searching in SQL queries. | Requires: ColdFusion 5

View UDF
Loading...
sqlSafe

Cleans string of potential sql injection. | Requires: ColdFusion 5

View UDF
Loading...
VerifyDSN

Verifies a DSN is working. | Requires: ColdFusion MX

View UDF
Loading...

Search CFLib.org


Latest Additions

Ryan Thompson-Jewell Ryan Thompson-Jewell added
ListSplit
1 day(s) ago

Nathan Dintenfass Nathan Dintenfass added
RowsToColumns
1 day(s) ago

Barney Boisvert Barney Boisvert added
indentXml
1 day(s) ago

Barney Boisvert Barney Boisvert added
REReplaceCallbac...
1 day(s) ago

Top Rated

Rob Brooks-Bilson                                 FolderSize
Rated 5.0, 7 time(s)

Nick Giovanni                                     UniqueValueList
Rated 5.0, 5 time(s)

James Sleeman                                     QuickSort
Rated 5.0, 3 time(s)

Jeff Howden ListDeleteDuplic...
Rated 5.0, 3 time(s)

Created by Raymond Camden / Design by Justin Johnson