That's one of the brightest ideas I've heard about ColdFusion programming.
Good job, Tony.
---mark
----- Original Message -----
From: "Tony Schreiber" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, May 26, 2001 7:48 PM
Subject: Re: bulk updating database from txt file
> I have a cf template (well a couple) that actively (via http) solicit
> prices from websites. I had one going that did 300,000 price updates over
> several days.
>
> The best way I found to run this template was via the command line, ie:
>
> e:\cfusion\bin\cfml.exe e:\webroot\scan\pricereport.cfm
>
> No request timeouts, no hung browser windows...
>
> > I have a largish access database (30,000 records) which needs to be
updated
> > from a comma delimited text file.
> > There will be some updated records and some new records.
> > I am not sure how to begin with this
> > My worries are
> > how do I do an update loop when some records will have to be inserted
and
> > some updated.
> > Also this would presumably take a long time to do - how do I handle this
> >
> > Any suggestions welcome (assume I am a bear with very little brain) or
any
> > tutorials on this sort of thing.
> >
> > many thanks
> >
> > Seamus
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
