Client variables purge query

October 30, 2009 by Jean

Queries run by ColdFusion to purge database stored client variables in CDATA:

delete FROM CDATA WHERE CFID in (SELECT CFID from CGLOBAL where CGLOBAL.lvisit < '2008-11-19 14:18:03')

and then in CGLOBAL:

delete FROM CGLOBAL WHERE CGLOBAL.lvisit < '2008-11-19 14:18:03'

In: ColdFusion