CFLib.org – Common Function Library Project

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:

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 (&#109;&#105;&#99;&#104;&#97;&#101;&#108;&#64;&#115;&#108;&#97;&#116;&#111;&#102;&#102;&#46;&#99;&#111;&#109;) 
 * @version 1, April 1, 2003 
 */
function MSSQLInt(number) {
	if (val(number) LT -2147483648 OR val(number) GT 2147483247) return 0;
	else return number;
}
</cfscript>