CFLib.org – Common Function Library Project

DatabaseLib

Last updated January 8, 2013 / 24 Released UDF(s)
backupDatabase

Backs up a database to a zip file. | Requires: CF8

cfStoredProcSearch

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

EksporSQLData

Eksport SQL Data to Mysql | Requires: CF6

exportSQLTable

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

GetDB2TimeStamp

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

GetDSNs

Gets a list of DSNs. | Requires: CF6

getGeneratedKey

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

getQueryColumns

Returns list of query columns in order as defined by SQL query. | Requires: CF6

isInTransaction

Returns true if the call to it is within a CFTRANSACTION block | Requires: CF9

isORM

Validates if item is orm entity or collection. | Requires: CF9

IsSQLInject

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

limit

Mimics MySQL limit's function. | Requires: CF6

MSSQL2CFSQLDT

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

MSSQLCreateUUID

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

MSSQLInt

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

MySQLDT2TS

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

MySQLTS2DT

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

NullColumn

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

qryOrderToTable

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

QueryGetSQL

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

removeSQLStops

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

showDatabaseTablesMySQL

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

smartSearch

Smart boolean searching in SQL queries. | Requires: CF5

VerifyDSN

Verifies a DSN is working. | Requires: CF6

Search CFLib.org


Latest Additions

Kevin Cotton added
date2ExcelDate
May 5, 2016

Raymond Camden added
CapFirst
April 25, 2016

Chris Wigginton added
loremIpsum
January 18, 2016

Gary Stanton added
calculateArrival...
November 19, 2015

Sebastiaan Naafs - van Dijk added
getDaysInQuarter
November 13, 2015

Created by Raymond Camden / Design by Justin Johnson