I meant one particular set of these variables to see if a particular visitor has been there before
-----Original Message----- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 4:55 PM To: [EMAIL PROTECTED] Subject: testing to see if cfid and cftoken already exist in database I'm trying to get my head around client variables ... in a scenario where they're placed in a database for later testing for existence ... but I can't figure out how to test for there existence??? I know this is probably a no-brainer, but that would be me at this point Here's how I'm insert them into a database (I assume this is a reasonable way): <cfquery datasource="jobs_available" dbtype="odbc"> INSERT INTO tracking (LastVisit, token, cfid) VALUES (#Client.LastVisit#, '#client.cftoken#', '#client.cfid#') </cfquery> Now once these are in the database, how do I test for there existence in subsequent visits?? Tim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
