CFLib.org – Common Function Library Project

DatabaseLib

Last updated February 15, 2008 / 16 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...
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...
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...
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

Topper Topper added
getCurrentURL
1 hour(s) ago

Daniel Chicayban Daniel Chicayban added
IsListInList
1 day(s) ago

Jeff Howden Jeff Howden added
CSVFormat
9 day(s) ago

Tom de Manincor Tom de Manincor added
flattenStruct
10 day(s) ago

Troy Pullis Troy Pullis added
iCalUS
10 day(s) ago

Created by Raymond Camden / Design by Justin Johnson