SQL 7
----- Original Message -----
From: "Brian Thornton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, April 22, 2001 11:41 AM
Subject: Re: Updating 1000s of records
> 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
