UPDATE Table_name SET XHome=XHome+1 WHERE URL=#CGI.SCRIPT_NAME# and #cgi.remote_addr# <> IPaddress
This might help you out by seting the userID to the url and this will onl y update the database if the IP is unique. You might want to play with this to see if you can make it work for you. ----- Original Message ----- From: "remi39" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 3:22 PM Subject: Same Stat Question...pleaaaaaaaase help Hi there, I build a resume bank and would like to provide my user the ability to see their own stat through thier browser...but i don't want to grant them access to my log files. Here is the code i run when someone browse a page : XHome is the counter (and a column name in my SQL Server DB) updated everytime a user see my page Resume.cfm I call this simple stored proc in Resume.cfm every time a user see this page CREATE PROCEDURE ... UPDATE Table_name SET XHome=XHome+1 WHERE UserID=@UserID The problem is: 1/ sometimes the counter is not updated : is there a cache problem or something else...i don't know? 2/ More important : i don't think it's The Solution as i don't want to kill my server (shared hosting ! ). There will have a lot of traffic if i update my counter (my DB) everytime a user launch this page! Should i increment a text file? Am i missing something...Any advice or idea would be appreciate... thanks Remi van der Deure ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
