> Example: I have a template which is running a query that is
> attempting to
> pull millions
> of records. Is there a way I can setup another template which will
> interrupt the query template?
> Or if a template sets up an infinite loop, is there a way to
> terminate it
> from another template?
Remeber also that the server is running before the information "sent" to the
browser, also, on long generation pages, since the server is running faster
than the browser sees, the server would be way ahead of any checks.
The best way to do this is to check the loop wouldn't be infinite before
it's run, or put some limitation into the SQL (i.e. select top 5000 * from
myTable)
It would slow down the creation, but select Count(*) from myTable where ....
would product the number of rows, and if it's too many, then refuse to run
it...
BTW, I don't recommend using * in any selects, as it's slower than
specifying the column names, even if there are loads of columns...
HTH
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
