You should understand the structure of the database tables used to store client information if you have to migrate client variable data to another data source.
Client variables stored externally use two small database tables with the simple structure shown in the following tables:
CDATA |
|
Column |
Data Type |
cfid |
char(20) |
app |
char(64) |
data |
memo |
CGLOBAL |
|
Column |
Data Type |
cfid |
char(20) |
app |
memo) |
lvisit |
date |
Data types shown in these tables are those used for a Microsoft Access database. Your database will require different data types. For information about creating client variable tables, see the book Developing ColdFusion Applications.