MSSQLInt(number)
Last updated April 1, 2003
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
Tayo Akinmade added
arrayTrim
10 day(s) ago
Will Belden added
longTime
15 day(s) ago
James Sleeman added
quickSort
25 day(s) ago
Ben Forta added
GetHostAddress
28 day(s) ago
Top Rated
EksporSQLData
Rated 5.0, 16 time(s)
backupDatabase
Rated 5.0, 13 time(s)
indentXml
Rated 5.0, 10 time(s)
generateSsccAsn
Rated 5.0, 4 time(s)