writing/testing for cookie 1

[leadman]

Im trying to write a cookie to clients machines and then test for the existence of the cookie as a way of counting unique hits. Something is wrong but i cant tell what. Here's what i did. FIrst i check for the existence of the cookie and if its not there i increment the counter and write the cookie (here is the code):

<cfif not isdefined(&quot;Cookie.visitedsurvey&quot>
<cfquery name=&quot;updateUnique&quot;
datasource=&quot;mydb&quot;
dbtype=&quot;ODBC&quot;>
UPDATE counter
SET uniqueVisitors = (uniqueVisitors + 1)
WHERE page = 'survey'
</cfquery>
<cfcookie name=&quot;visitedsurvey&quot; value=&quot;&quot; expires=&quot;30&quot;>
</cfif>
</cflock>

for some reason, the uniqueVisitors field increments up every time i refresh the page. Anyone know why? (my browser does accept cookies)

 

[kristof]

Hi leadman,

Maybe you should give the cookie a value, not just an empty string? It could be that the cookie isn't written if it has no content.

Gtz,

Kristof -------------------
Check out my new site:

http://kristof.freewebspace.com/

Any suggestions are more than welcome.
There's a LOT of work to do, so judge fairly.

 

[KevinFSI]

Does it work if you physically delete the cookie, or set EXPIRES=&quot;NOW&quot;? Kevin
slanek@ssd.fsi.com

 

[leadman]

putting a value in didnt help. and the cookie soesnt seem tto have been written - cant find it. hmmm - and i thought writing a cookie would be easy....

 

[KevinFSI]

Are you using <CFLOCATION> anywhere on the page? If so, <CFCOOKIE> will not be set. Kevin
slanek@ssd.fsi.com

 

[leadman]

no <cflocation> but the whole thing is in a <cflock> tag - does that matter?

 

[KevinFSI]

Not sure. Only thing I can suggest is taking the <CFLOCK> out and giving it a try.

Also, try creating a blank page with only <CFCOOKIE> in it. Run the page and see if you have a cookie set then. At least then you'll know if the problem is with the cookie, or the other code in your page. Kevin
slanek@ssd.fsi.com

 

[leadman]

aha! it was the cflock the whole time - okay, thanks for the help

 

[KevinFSI]

Cool. I've noticed there are certain things you just can't do when trying to set a cookie.

Glad it worked out. Kevin
slanek@ssd.fsi.com