i think he's referring to the CFID and CFTOKEN storage that CF does. that requires the registry (really bad!), an ODBC source (best!), or cookies (fair to middling).
christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -----Original Message----- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 2:52 PM To: CF-Talk Subject: RE: Client Variable Database Storage If you don't expect a lot of traffic, just use session variables. I only use client variables on sites that will either have a lot of traffic, or ones that I would like to move one day to a clustered enviroment. Use session variables (with locking), it will make your life easier. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -----Original Message----- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 2:50 PM To: CF-Talk Subject: RE: Client Variable Database Storage Matt and Tony, Thanks for the quick response. Your messages confirmed some of my assumptions. Here's what my hosting company support had to say about it: > Hi Chris, we create a DSN for each individual client who wants CV > storage. You could use either an AccessDB or an MSSQL db for this. It > is probably best to have an empty one, as the CF Administrator will > create the tables necessary. As you already have a DSN associated with > this account an additional one would incur a $5/month charge. You could > avoid this charge by using your current database for CV storage, as the > table names that are created are fairly unique. However, do this at > your own risk. Please let us know if you have any further questions. I think I will be able to work with just having them configure my already existing datasource to store client vars. It's for a fairly small site and I don't really expect lots of traffic. Thanks again. Chris Montgomery [EMAIL PROTECTED] Airtight Web Services Web Development, Web Project Management, Software Sales Macromedia Sales & Consulting Partner 210-490-3249/888-745-7603 > -----Original Message----- > From: Matt Robertson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 03, 2002 1:28 PM > To: CF-Talk > Subject: RE: Client Variable Database Storage > > > Chris, > > You can put your client vars in any dsn you like, so long as you specify > that dsn as a client var repository in the CF Administrator. If you've > already created your tables, just leave the ''create tables'' choice > unchecked when you do the above. > > This lets you specify multiple client var datasources, one for each > client assuming each client has its own dsn. You may or may not want to > do that. I used to but mostly don't anymore, preferring instead to > keeping those w/generic needs in a server-wide db. I have some clients > whose expirations differ from the norm, so I break them out into their > own db's. > > I'm not sure this is something you can really manage with a shared host. > You'll have to ask them directly if they can set you up. > > --Matt Robertson-- > MSB Designs, Inc. > http://mysecretbase.com > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists