MACROMEDIA ColdFusion MX, Develop Manual, Page: 323 / 860

Configuring and using client variables 323
The CDATA table must have the following columns:
The CGLOBAL table must have the following columns:
Note: Different databases use different names for their data types. The names in the preceding
tables are common, but your database might use other names.
To improve performance, you should also create indexes when you create these tables. For the
CDATA table, index these cfid and app columns. For the CGLOBAL table, index the cfid
column.
Specifying client variable storage in the Application.cfm file
The
cfapplication
tag
clientStorage
attribute lets you override the default client variable
storage application location. The following line tells ColdFusion to store the client variables in
the mydatasource data source:
<cfapplication name"SearchApp"
clientmanagement="Yes"
clientstorage="mydatasource">
Using client variables
When you enable client variables for an application, you can use them to keep track of long-term
information that is associated with a particular client.
Client variables must be simple data types: strings, numbers, lists, Booleans, or date and time
values. They cannot be arrays, record sets, XML objects, query objects, or other objects. If you
must store a complex data type as a client variable, you can use the
cfwddx
tag to convert the data
to WDDX format (which is represented as a string), store the WDDX data, and use the
cfwddx
tag to convert the data back when you read it. For more information on using WDDX, see
Chapter 31, “Using WDDX,” on page 702 .
Column Data type
cfid CHAR(64), TEXT, VARCHAR, or any data type capable of taking variable length
strings up to 64 characters
app CHAR(64), TEXT, VARCHAR, or any data type capable of taking variable length
strings up to 64 characters
data MEMO, LONGTEXT, LONG VARCHAR, CLOB, or any data type capable of
taking long, indeterminate-length strings
Column Data type
cfid CHAR(64), TEXT, VARCHAR, or any data type capable of taking variable length
strings up to 64 characters
data MEMO, LONGTEXT, LONG VARCHAR, CLOB, or any data type capable of
taking long, indeterminate-length strings
lvisit TIMESTAMP, DATETIME, DATE, or any data type that stores date and time
values