CFLib.org – Common Function Library Project

DatabaseLib

Last updated July 24, 2011 / 22 Released UDF(s)
Download Library

Previous 20 / Next 20

cfStoredProcSearch

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

View UDF
Loading...
EksporSQLData

Eksport SQL Data to Mysql | 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...
getQueryColumns

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

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

Previous 20 / Next 20

Search CFLib.org


Latest Additions

Dave Anderson Dave Anderson added
iniToStruct
20 day(s) ago

Dave Anderson Dave Anderson added
deDupeArray
20 day(s) ago

Richard Richard added
dice
22 day(s) ago

Isaac Dealey Isaac Dealey added
getRelative
a while ago

Top Rated

Darwan Leonardo Sitepu backupDatabase
Rated 5.0, 22 time(s)

Barney Boisvert indentXml
Rated 5.0, 10 time(s)

Kevin Pepperman generateSsccAsn
Rated 5.0, 4 time(s)

Raymond Camden highlightAndCrop
Rated 5.0, 4 time(s)

Created by Raymond Camden / Design by Justin Johnson