I didn't get it to work for me. I'm using database-driven client vars,
specifically with MS SQL 7 as the db. Here is the code that will drop the
atomic bomb on your client vars and blow them to dust...
Do a SQL query that has the following code:
DELETE from #db_owner#.CDATA
WHERE CFID = '#Cookie.CFID#:#Cookie.CFTOKEN#' and app =
'#application.applicationname#'
Now, take note, I've got this variable in there, #db_owner#. You note also,
that the table being called is refered to as [owner].[table] instead of
plain [table]. Why? Cuz I watched this code execute, and if you don't
explicityly declare the table owner, the SQL code will not execute! And to
make it worse, it doesn't even throw an error!
As far as the explicit [owner].[table] refrence goes, in my case, the table
owner is -not- "dbo", so "dbo.CDATA" doesn't work. I tried. It turns out it
was the same account I use from CF Admin to call the SQL table. Anyhow, I
have no doubt if you monkey with this you'll figure it out and get it to
work. And when it does, since its just a SQL table, you can verify with your
own two eyes (or one if you have a glass eye) that the client var is indeed
gone.
If you have MS SQL, crack Enterprise Manager open, cruise over to the db
where you store your client variables, and actually WATCH what happens when
you do a DeleteClientVar, or some other call to kill the client vars.
> -----Original Message-----
> From: Sean Renet [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, April 23, 2001 9:18 AM
> To: Fusebox
> Subject: Re: Deleting client variables
>
> Ryan's tag is cool if you need the added functionality, however if all you
> want to do is get rid of them all, you simply....
> <CFLOOP list="#getclientvariableslist()#" index="counter">
> <cfoutput>
> <cfset temp = DeleteClientVariable("#counter#")>
> </cfoutput>
> </CFLOOP>
> ----- Original Message -----
> From: "Ryan Wood" <[EMAIL PROTECTED]>
> To: "Fusebox" <[EMAIL PROTECTED]>
> Sent: Monday, April 23, 2001 5:49 AM
> Subject: RE: Deleting client variables
>
>
> > I wrote a custom tag to do just that. You can get it at
> > http://www.sourcescape.com/index.cfm?fuseaction=developer. Just set the
> > TIMEOUT attribute to "now".
> >
> > Ryan
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, April 22, 2001 4:31 PM
> > To: Fusebox
> > Subject: Deleting client variables
> >
> >
> > Can anyone tell me the best way to delete all client variables for a
> user?
> >
> > I've tried using GetClientVariableList and DeleteClientVariable, but I'm
> > somehow getting corrupt CV names (possibly from CF_RETURNFUSEACTION?).
> >
> > I've tried setting the DATA field to NULL in the database for that user,
> but
> > I'm getting strange errors after that.
> >
> > Any ideas?
> >
> > Thanks,
> > Shannon
> >
> > Shannon Hicks, Senior Developer
> > Allaire Certified ColdFusion Developer
> > Brainbench Certified Master ColdFusion Developer
> > duoDesign eBusiness Architects
> > Design : Develop : Deploy
> >
> > 847-491-3000 main : [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> > 847-491-3100 fax : www.duodesign.com <http://www.duodesign.com>
> > 847-491-7128 direct : www.chicagoangels.org
> <http://www.chicagoangels.org>
> >
> >
> >
> > -----Original Message-----
> > From: Hal Helms [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, April 21, 2001 10:43 PM
> > To: Fusebox
> > Subject: RE: Storing CF Code in the database
> >
> >
> > I worked with Rick Moon recently on architecting a Latin America portal
> for
> > Fox where we wanted to do the same thing. We ended up creating a RAM
> disk
> > and writing the CF files to this. It was VERY fast, as you might
> imagine.
> >
> > Hal Helms
> > Team Allaire
> > [ See www.halhelms.com <http://www.halhelms.com> for info on training
> > classes ]
> >
> >
> > -----Original Message-----
> > From: Tim Lieberman [mailto:[EMAIL PROTECTED]]
> > Sent: Saturday, April 21, 2001 8:40 PM
> > To: Fusebox
> > Subject: Storing CF Code in the database
> >
> >
> > I'm working on a pretty nice system for content management here.
> >
> > The problem I'm having, is I would like to be able to store CF templates
> > in my database, and have CF parse them. The reason for this is that
> I've
> > written custom tag interfaces to various "elements" that site admins can
> > use to do things like insert images in an article without resorting to
> HTML.
> >
> > Is there a way to do this, besides writing a temp file to disk and then
> > including it via CFINCLUDE?
> >
> > It would be really nice to have a ParseCFML function which would take a
> > string
> > and treat it like input. Leave non-CFML content alone, and execute any
> CF
> > content.
> >
> > Can this be done?
> >
> > TIA
> >
> > -Tim
> >
> >
> > Archives: http://www.mail-archive.com/[email protected]/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
