Results 1 to 2 of 2

Thread: ColdFusion Client Variables Datasource

  1. #1
    Join Date
    Nov 2009
    Posts
    99

    Default ColdFusion Client Variables Datasource

    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
    Code:
     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
    Code:
    CREATE TABLE cglobal (
              cfid varchar(64) NOT NULL default '',
              data longtext NOT NULL,
              lvisit timestamp,
              KEY cfid (cfid),
              KEY lvisit (lvisit)
         );
    Last edited by jakeh; August 18th, 2012 at 01:22 PM.

  2. #2
    Join Date
    Feb 2013
    Location
    Indianapolis, IN. 46205
    Posts
    1

    Thumbs up Cf client db table exists

    You could also add this in the SQL statement to check for the existence of the table already.

    CREATE TABLE IF NOT EXISTS CDATA

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •