Yeah, I thought of that, unfortunately, I can't rely on cookies. Life would be so much easier if I could just use cookies. I know this will start a thread, but with IE6, MS has made it so easy for users to turn off cookies, we have found that we loose customers on our e-commerce sites, so we have to code the CFTOKEN into all our form fields. You will notice that most major sites such as Amazon work without cookies. I think this is a trend and we will see more of this in the future. So if you are dealing with the general public, not an internal site, I think more and more people will be turning off cookies because of the "privacy" hype. Just my 2 cents, I may be wrong, but our client demanded that the e-commerce sites work without cookies. We use CLIENT vars on all the pages because we have to keep track of the session. We can't use session vars because they don't scale.. (They don't work behind a load balancer). So, my dilemma.... I might have to change all the code to store the client vars myself in my own db as you suggested if MM doesn't fix the problem.. You say you purge your ccdata and cglobal every night. What happens if you have a user tied to a client var and you delete it while they are in the site? I am not sure this will work for me. I purge them after two days. I had it weekly, but got too many error,s setting to 2 days helped a little, but as traffic builds, it's getting worse. I JUST CAN'T BELIEVE MM WILL NOT FIX THIS. Yes MM, I am shouting...Do you hear us???? It's been on the bug list as a sev 2 since 4.5. PLEASE FIX THIS!!!!!!!! Do they even listen to this list??? Sorry for shouting guys... It has been a long night... Best Regards, Joe "underbar" Hansen
----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 16, 2003 9:53 AM Subject: Re: CDATA dup insert error Again > I know this doesn't solve your problem... but... you can always "roll your > own". Heck, all it is (more or less) is setting a cookie on the client's > browser with a UUID then writing/updating a database table. Toss the "read" > routine in your application.cfm page and you'll end up reading the client's > info every time. > > Or, even better... if your application doesn't need that data every time... > you can make a call to the routine only when you do need it. That's even > more efficient as it eliminates unneeded calls to the database. > > I personally have never relied on client variables for much more than > session stuff. I purge my CDATA and CGLOBAL tables every night and never > have any problems. > > -Novak > > ----- Original Message ----- > From: "Webmaster" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, January 16, 2003 4:46 AM > Subject: Re: CDATA dup insert error Again > > > > I just read a long thread on this and MM has it as a bug, but it seems > they > > are not going to fix it. What a rip... > > > > > > ----- Original Message ----- > > From: "Webmaster" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Wednesday, January 15, 2003 11:22 PM > > Subject: CDATA dup insert error Again > > > > > > > Hi, > > > I am still getting this error. The last time I asked the list we went > > > around in circles about locking and purging the client var data store. > > > Well, the purge is working fine. I have it set to one week and there > are > > > only a weeks worth of entries in the db. I don't understand how this > can > > > happen. I am using the Uuid version of the cftoiken so it is supposed > to > > > guarantee unique values (TechNote 22427) > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

