Gee, I keep foretting details.
No, it's not comma delimited. I have to use the Mid() function to pick out
the substrings from a plain text ASCII file.
John
-----Original Message-----
From: Bruce Heerssen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 12, 2000 4:18 PM
To: CF-Talk
Subject: RE: SERVER TIMES OUT ON LONG SCRIPT
I don't suppose the file is in comma or tab delimited format? Your message
implies that. If it is, you can use it as a coldfusion datasource. That
should
significantly speed up the process. You can also use sql statements and CF
together to step through the records if necessary.
hth
- Bruce
> -----Original Message-----
> From: John Grubb [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 12, 2000 2:31 PM
> To: CF-Talk
> Subject: SERVER TIMES OUT ON LONG SCRIPT
>
>
> I am running a script that, basically, loops over a file of about 225,000
> lines (opened via <CFFILE>), parses the separate data elements from the
> fields in each line, puts each substring in a variable, then does an
insert
> query of that record, using the variables, into a couple of tables in an
MS
> SQL 2000 database. Once the entire file has been read, parsed and
inserted,
> I clear the file variable, send a javascript document.write to an html
fram
> to show the progressopen the next template (have also used a <CFINCLUDE>),
> which resets some flags in the database via an UPDATE.
>
> After the insert query, I get the following error:
>
> Error Occurred While Processing Request
>
> Error Diagnostic Information
>
> Request canceled or ignored by serverServer busy or unable to fulfill
> request. The server is unable to fulfill your request due to
> extremely high traffic or an unexpected internal error. Please attempt
your
> request again (if you are repeatedly unsuccessful you
> should notify the site administrator). (Location Code: 26)
>
>
> Please inform the site administrator that this error has occurred (be sure
> to include the contents of this page in your message to the
> administrator).
>
> Any ideas?
>
> John Grubb
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
