PDA

View Full Version : ColdFusion Client Variables Datasource



jakeh
January 25th, 2012, 02:11 PM
If you need your datasource set up as a ColdFusion Client Variables Store, you will need to request our support team do this for you.

Please note, if your datasource MySQL DSN, you'll need to create the necessary tables prior to having the Client Variable Store set up. To do this you would need to create two tables, one named "cdata" and one named "cglobal". The SQL you'd use to create those tables is below:

Table: cdata

CREATE TABLE cdata (
cfid varchar(64) NOT NULL default '',
app varchar(64) NOT NULL default '',
data longtext NOT NULL,
PRIMARY KEY (cfid,app)
);

Table: cglobal


CREATE TABLE cglobal (
cfid varchar(64) NOT NULL default '',
data longtext NOT NULL,
lvisit timestamp,
KEY cfid (cfid),
KEY lvisit (lvisit)
);

Link Worx Seo
February 12th, 2013, 01:38 PM
You could also add this in the SQL statement to check for the existence of the table already.

CREATE TABLE IF NOT EXISTS CDATA