MACROMEDIA COLDFUSION 4.5-ADMINISTRING COLDFUSION..., Manual

Page: 72 / 350

50 Administering ColdFusion Server
Create client variable data source tables
Use this option to allow ColdFusion to create the tables necessary for client variables
when you first configure the data source for this purpose. As you configure other
servers in your cluster to use this client variables data source, be sure to disable the
option for ColdFusion to create the necessary tables. If you inadvertently enable
automatic table generation, ColdFusion generates a SQL error because it tries to create
tables that already exist.
Migrating Client Variable Data
If you need to migrate your client variable data to another data source, you need to
know the structure of the database tables used to store this information. Client
variables stored externally use two small database tables with the following simple
structure. Data types shown in these tables are those used for a Microsoft Access
database. Your database may require different data types.
Creating client variable tables
You can use the following example ColdFusion page as a model for creating client
variable database tables in your own database. Not all databases support the same
column data type names, so you may have to alter some data types for your database.
Refer to your database documentation for the proper data type.
CDATA
Column Data Type
cfid char(20)
app char(64)
data memo
CGLOBAL
Column Data Type
cfid char(20)
data memo
lvisit date