MACROMEDIA COLDFUSION MX 61-DEVELOPING COLDFUSION MX, Develop Manual

Page: 81 / 860

Validating data types 81
•
Use the
cfqueryparam
tag in a SQL WHERE clause to validate query parameters. For
information on this technique, see Chapter 20, “Using cfqueryparam,” on page 435 .
Note: Data validation using the cfparam, cfqueryparam , and form tags is done by the server.
Validation using
cfform
tags is done using JavaScript in the user’s browser, before any data is sent
to the server.
Using the cfparam tag to validate the data type
The
cfparam type
attribute lets you validate the type of a parameter. You can specify that the
parameter type must be any of the following values:
For example, you can use the following code to validate the variable BirthDate:
<cfparam name="BirthDate" type="date">
If the variable is not in a valid date format, an error occurs and the page stops processing.
Type value Meaning
any Any value
array Any array value
binary Any binary value
boolean True, False, Yes, or No
date Any value in a valid date, time, or date-time format
numeric Any number
query A query object
string A text string or single character
struct A structure
UUID A Universally Unique Identifier (UUID) formatted as XXXXXXXX-XXXX-XXXX-
XXXXXXXXXXXXXXX where X stands for a hexadecimal digit (0-9 or A-F).
variableName A valid variable name