> information into a database. For each entry in the log file,
> the script must make two very simple select query calls to
> one data source, and then insert all of the data into a second
> data source. The first couple of log files were parsed just
> fine ... they averaged about 500 entries. The file I am
> working with now is much longer and the script is bailing out
> every time somewhere around entry number 725 ( +/- 50 ). Each
> time, it quits on a different record, so there is not one
> record that is causing the issue, but it always quits in the
> same general area.
>
> The CF error message is stating that 'The Request has exceeded
> the allowable time limit Tag: CFQUERY'. The query is a very
> simple select query ....
>
> SELECT OBJECTID
> FROM PTUSERS
> WHERE NAME = <cfqueryparam cfsqltype="cf_sql_varchar"
> maxlength="255" value="#auditEntry.name#">
>
> This query has already run 700+ times (once for each log
> entry), but somewhere in the low 700s, it quits.
>
> Any suggestions as to what might be going on?
If you're looping over the query within a single call to your CF page, the
page itself is probably timing out. You can address this by overriding the
default timeout. With CFMX, you can do this using the CFSETTING tag at the
top of your page:
<cfsetting requesttimeout="999999">
With CF 5 or earlier, you can do this by embedding the RequestTimeout
variable within the URL you request to get to the file:
<a href="" the really long page</a>
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
