Kris and Andrew, thanks for your time.. I saw first two links, but not the third one. I still not clear, but will do some testing I guess.
In my scenario, I have setclientcookies yes and ofcourse sessionmanagement yes. I was trying to query the table for all unique sessions (select distinct (cfid+cftoken) from user_log ) for a time period but noticed that a given session id shows up again after x hrs for the same ip+browser+user_id combination. And that's what stumped me. Now I cann't do a simple query as above, but have to check the entry_time field and make sure if there is a time gap of 30 min or more between two entries, I need to mark it as start of new session. Here is what happens: user first hits, his session is created and logged. user navigates and leaves, comes back after say 10 hrs. His new entry still shows same cfid + cftoken combination as before. I didn't understand if this is a new session but just with old values automatically detected from previously populated cookie values, or if this is same session as before (but it is set to expire after 30 min). What I don't understand is, in the next round when user visits after a long gap, should not a new cfid and cftoken values be created and updated into the cookie values? Why is that not happening? Like I said I guess I need to setup a test site and play with it. Trying to save some time.. Thanks a lot for your help. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302875 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
