Isn't this information already stored under CGLOBALS as a client variable?
-----Original Message-----
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 22 April 2001 20:18
To: CF-Talk
Subject: Updating 1000s of records
Our application is built like that so I'm reciving a daily .txt file with
1000s of lines. each line
with a unique number that is userID. userID that is on this text file means
he visited our site
in the last 24 hours (complex, I know.. bear with me)
I'm trying to find the best way to update 1000s rows of SQL 7 DB Table:
USERS.
with this information so that Colum LASTVISITEDDATE will have now() value
for each
person that was on that list.
Any brighter ideas then
.....loop list....
UPDATE .... WHERE userID='x
end loop
OR
UPDATE WHERE userID='x' OR userID='y' OR userID='....n...'
Thanks,
Michael Lugassy
Interactive Music Ltd.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists