SELECT * FROM Pages_temp
WHERE pageurl = '#CF_TEMPLATE_PATH#' AND hitdate = '#Dateformat(Now(),'mm/dd/yyyy')#'
INSERT INTO Pages_temp(pageurl,hitcount,hitdate)
VALUES('#CF_TEMPLATE_PATH#',1,'#Dateformat(Now(),'mm/dd/yyyy')#')
UPDATE Pages_temp
SET hitcount = hitcount + 1
WHERE pageurl = '#CF_TEMPLATE_PATH#' AND hitdate = '#DateFormat(Now(),'mm/dd/yyy')#'