CFLib.org – Common Function Library Project

DatabaseLib

Last updated January 08, 2013 / 24 Released UDF(s)
MSSQLCreateUUID

Creates UUIDs safe for use in MSSQL UNIQUEIDENTIFIER fields. | 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

GetDB2TimeStamp

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

VerifyDSN

Verifies a DSN is working. | Requires: CF6

IsSQLInject

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

NullColumn

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

QueryGetSQL

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

GetDSNs

Gets a list of DSNs. | Requires: CF6

MSSQLInt

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

showDatabaseTablesMySQL

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

exportSQLTable

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

removeSQLStops

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

cfStoredProcSearch

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

getGeneratedKey

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

smartSearch

Smart boolean searching in SQL queries. | Requires: CF5

limit

Mimics MySQL limit's function. | Requires: CF6

MSSQL2CFSQLDT

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

qryOrderToTable

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

isORM

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

EksporSQLData

Eksport SQL Data to Mysql | Requires: CF6

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

backupDatabase

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

Search CFLib.org


Latest Additions

Raymond Camden added
QueryDeleteRows
November 04, 2017

Leigh added
nullPad
May 11, 2016

Raymond Camden added
stripHTML
May 10, 2016

Kevin Cotton added
date2ExcelDate
May 05, 2016

Raymond Camden added
CapFirst
April 25, 2016

Created by Raymond Camden / Design by Justin Johnson