CFLib.org – Common Function Library Project

MSSQLInt(number)

Last updated April 1, 2003
Download UDF

author

Michael Slatoff                                   Michael Slatoff

Version: 1 | Requires: ColdFusion 5 | Library: DatabaseLib

Description:
Checks to see if the number is a valid SQL-92 integer. If it is valid, return number else return 0.

Return Values:
Returns a number.

Example:

<!---
<cfquery name="EmployeeDetails" datasource="Intranet">
    SELECT
        EmployeeID, FirstName, LastName
    FROM
        Employees
    WHERE
        EmployeeID = <cfqueryparam value="#MSSQLInt(ATTRIBUTES.EmployeeID)#" cfsqltype="CF_SQL_INTEGER">
</cfquery>
--->

Parameters:

Name Description Required
number Number to check. Yes

Full UDF Source:

<cfscript>
/**
* Checks to see if the number is a valid SQL-92 integer.
* Rewritten by RCamden. Code didn't work as submitted.
*
* @param number      Number to check. (Required)
* @return Returns a number.
* @author Michael Slatoff (michael@slatoff.com)
* @version 1, April 1, 2003
*/

function MSSQLInt(number) {
    if (val(number) LT -2147483648 OR val(number) GT 2147483247) return 0;
    else return number;
}
</cfscript>

Search CFLib.org


Latest Additions

Jose Diaz-Salcedo Jose Diaz-Salcedo added
cfRssFeed
2 day(s) ago

Raymond Compton Raymond Compton added
structBlend
23 day(s) ago

Duncan Duncan added
IsZIPUK
23 day(s) ago

Todd Sharp Todd Sharp added
getTagContentAll
29 day(s) ago

Gerald Guido Gerald Guido added
ListReturnDuplicat...
1 month(s) ago

Created by Raymond Camden / Design by Justin Johnson