[cfaussie] RE: Long running query

[Barry Beattie]

Brian, you're in good company - we have to do something similar soon.   we were looking at CF7's asyncronous gateways to do something like this (but our clients are all on standard and won't change).   how do you handle the browser waiting for a response (while it's doing the query and writingthe file)? we can't access asyncronous CF gateways so async AJAX calls should work instead (we hope)   We have to replace a reporting system called "RMS" that runs these long reports and dumps them into a specific file directory for the user to get when they're ready. You do have the standard issues with file clean-ups and maintaining a handle for the user to get to the file - we can't trust the client setting up cfmail so emailing the file is no-go.   just a couple of thoughts (hoping there's an even easier way)   cheers barry.b   (PS: CFUG tonight at BCC city library meeting rooms - see you there? - b) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of KNOTT, Brian Sent: Tuesday, 3 May 2005 8:06 AM To: CFAussie Mailing List Subject: [cfaussie] Long running query I have a query that accesses a very slow database.  Most of the time it times out.  One way I was thinking of getting around this way to create a CF page that would run the query, export it to a file and them email the file to the user.  This works some of the time.    Is this the best method of doing it.  Optimising the database or speeding it up are not an option.   Brian Knott   ----------------------------------------------------------------------------------- This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities "Suncorp". Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/