MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER, Руководство пользователя

Страница: 86 / 160

74 Chapter 5 Basic ColdFusion Server Administration
Note
If a cluster of ColdFusion Servers uses this data source, ensure that only one
server is configured to purge client data.
Migrating Client Variable Data
To migrate your client variable data to another data source, you should know the
structure of the database tables used to store this information. Client variables
stored externally use two small database tables, like those shown in the following
tables:
Creating client variable tables
Use this example ColdFusion page as a model for creating client variable database
tables in your own database. However, keep in mind that not all databases support
the same column data type names. Refer to your database documentation for the
proper data type.
Sample table creation page
<!---- Create the Client variable storage tables in a datasource.
This example applies to Microsoft Access databases --->
<CFQUERY NAME="data1" DATASOURCE="#DSN#">
CREATE TABLE CDATA
(
cfid char(20),
app char(64),
data memo
)
</CFQUERY>
CGLOBAL Table
Column Data Type
cfid char(64)
data memo
lvisit date
CDATA Table
Column Data Type
cfid char(64)
app char(64)
data memo
install.book Page 74 Thursday, May 10, 2001 12:59 PM