CFLib.org – Common Function Library Project

DatabaseLib

Last updated May 30, 2010 / 21 Released UDF(s)
Download Library

Previous 20 / Next 20

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...
isORM

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

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...

Previous 20 / Next 20

Search CFLib.org


Latest Additions

Shawn Porter Shawn Porter added
DeMoronize
3 hour(s) ago

Chris Carey Chris Carey added
readPropertiesFi...
1 day(s) ago

Randy Johnson Randy Johnson added
lastDayofWeek
3 day(s) ago

Frank Marion Frank Marion added
sitemapPing
7 day(s) ago

Top Rated

James Sleeman                                     QuickSort
Rated 5.0, 3 time(s)

Barney Boisvert indentXml
Rated 5.0, 3 time(s)

Nathan Dintenfass                                 queryColumnsToSt...
Rated 5.0, 3 time(s)

Kevin Pepperman generateSsccAsn
Rated 5.0, 3 time(s)

Created by Raymond Camden / Design by Justin Johnson