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
cfRssFeed
2 day(s) ago
structBlend
23 day(s) ago
IsZIPUK
23 day(s) ago
getTagContentAll
29 day(s) ago
ListReturnDuplicat...
1 month(s) ago