User Guide

Table Of Contents
474 Chapter 20: Accessing and Retrieving Data
Using cfSqlType
The following table lists the available SQL types against which you can evaluate the
value
attribute of the
cfqueryparam tag:
Note: Specifying the cfsqltype attribute causes the DBMS to use bind variables, which can greatly
enhance performance.
BIGINT BIT CHAR DATE
DECIMAL DOUBLE FLOAT IDSTAMP
INTEGER LONGVARCHAR MONEY MONEY4
NUMERIC REAL REFCURSOR SMALLINT
TIME TIMESTAMP TINYINT VARCHAR