Adobe 38000827 Administration Guide - Page 20
Memory Variables Creating client variable tables
![]() |
UPC - 718659577186
View all Adobe 38000827 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 20 highlights
Creating client variable tables Use the following sample 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. For the proper data type, see your database documentation. Tip: The ColdFusion Administrator can create client variable tables for data sources that use bundled JDBC drivers. For more information, see the online Help. Sample table creation page CREATE TABLE CDATA ( cfid char(20), app char(64), data memo ) CREATE UNIQUE INDEX id1 ON CDATA (cfid,app) CREATE TABLE CGLOBAL ( cfid char(20), data memo, lvisit date ) CREATE INDEX id2 ON CGLOBAL (cfid) CREATE INDEX id3 ON CGLOBAL (lvisit) Memory Variables page You 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 MX. If you disable either type of variable in the Memory Variables page, you cannot use them in a ColdFusion application. 12 Chapter 2 Basic ColdFusion MX Administration
![](/manual_guide/products/adobe-38000827-administration-guide-a3ee674/20.png)