17
CONFIGURING AND ADMINISTERING COLDFUSION 10
Using the ColdFusion Administrator
L
ast
u
p
dated
7/9/2
01
2
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>
Memory Variables page
Use the Memory Variables page of the ColdFusion Administrator to enable application and session variables server-
wide. By default, application and session variables are enabled when you install ColdFusion. If you disable either type
of variable in the Memory Variables page, you cannot use them in a ColdFusion application.
You can specify maximum and default time-out values for session and application variables. Unless you define a time-
out value in an Application.cfc or Application.cfm file, application variables expire in two days. Session variables
expire when user sessions end. To change these behaviors, enter new default and maximum time-out values on the
Memory Variables page of the Administrator.
Note:
Time-out values that you specify for application variables override the time-out values set in the Application.cfc or
Application.cfm file.
You can also specify whether to use J2EE session variables. When you enable the J2EE session variables, ColdFusion
creates an identifier for each session and does not use the CFToken or CFID cookie value. For more information, see
the
Developing ColdFusion Applications
.