Chapter 3: Configuring ColdFusion Server
51
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>
<CFQUERY NAME="data2" DATASOURCE="#DSN#">
CREATE UNIQUE INDEX id1
ON CDATA (cfid,app)
</CFQUERY>
<CFQUERY NAME="global1" DATASOURCE="#DSN#">
CREATE TABLE CGLOBAL
(
cfid char(20),
data memo,
lvisit date
)
</CFQUERY>
<CFQUERY NAME="global2" DATASOURCE="#DSN#">
CREATE INDEX id2
ON CGLOBAL (cfid)
</CFQUERY>
<CFQUERY NAME="global2" DATASOURCE="#DSN#">
CREATE INDEX id3
ON CGLOBAL (lvisit)
</CFQUERY>
Enabling Application and Session Variables
Session and application variables are enabled with this option. These options override
any individual use of the CFAPPLICATION tag to enabled application or session
variables. If these variables are disabled in the Administrator, they cannot be used in
any ColdFusion application.
Specifying timeouts
Use the Application Variables and Session Variables Maximum Timeout and Default
Timeout settings to specify the lifespan for these variable types. The default timeout
Summary of Contents for COLDFUSION 4.5-ADMINISTRING COLDFUSION...
Page 1: ...Allaire Corporation Administering ColdFusion Server ColdFusion 4 5...
Page 10: ...x Administering ColdFusion Server...
Page 22: ...xxii AdministeringColdFusionServer...
Page 48: ...26 Administering ColdFusion Server...
Page 58: ...36 Administering ColdFusion Server...
Page 60: ...38 Administering ColdFusion Server Using ColdFusion in a Distributed Configuration 68...
Page 98: ...76 Administering ColdFusion Server...
Page 150: ...128 Administering ColdFusion Server...
Page 198: ...176 Administering ColdFusion Server...
Page 205: ...Chapter 6 Creating Scalable and Highly Available Web Sites 183 3 Click the DNS tab...
