Access or SQL?
----- Original Message -----
From: "Michael Lugassy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, April 22, 2001 3:17 AM
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
