判断参数是否符合SQL-92标准,如果符合则返回该参数的值,否则返回0.

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

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