In many cases, you may wish to persist your client variables somewhere other than a cookie. ColdFusion provides the ability to use your ColdFusion datasource as a client datastore.

Before you can use your datasource as a client variables datastore, you’ll need to create the necessary tables. To do this you would need to create two tables, one named cdata and one named cglobal. The proper schema for these tables can be found below. Please note that if you don’t create the proper schema, then client variables won’t persist and the failure is silent other than a ColdFusion log entry.

Table: cdata

Table: cglobal