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