-- "Stewart, Clay" <[EMAIL PROTECTED]> on 01/10/02 14:11:03 -0500
> What I am looking for, if possible, is to cancel the DBI call when the
> user hits cancel on the client machine.
If you add a "Cancel" button w/ arg's identifying the query
one CGI should be able to use it to blast a query run from
another. Trick there is to pass back either a session ID
(security hole) or unique value used to locate the session
ID (better) back when the person hits "submit". If you are
using session ID's to handle the requests they woudl be a
good bet. When the "cancel" or new query request comes in
then check for a running query and stop it (e.g., via signal)
before running the new one.
I've had reasonable luck with $SIG{USR1} handlers for
this kind of thing in Apache.
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
+1 800 762 1582