How do I download the results of a large Query
I would like to set up a link to some SQL query results in comma delimited ascii that will download the data rather than display it. I am having two problems. First the data is coming up in the browser and I want them to download it without having to right click and select download. Second, before the SQL is completed the browser times out. I think if I solve the first problem, the second will be Ok, Any ideas? Dennis Baker Information Systems Manager, St. Joseph's Medical Resources
You will need to use an external python method. I am currently writing one that will take any sql query and a file name as its parameters and put the results of the query into the file as comma or tab delimited records with or without the the field names in the first record. Will post info here when I have it completed __________________________________________________________________ Jim Sanford . Database Engineer / \ / Accelerated Technology, Inc. / / 720 Oak Circle Drive East / / \ Mobile, AL 36609 / / \ Voice: 334-661-5770 fax: 334-661-5788 / \ E-Mail: jsanford@atinucleus.com Web: http://www.atinucleus.com Nucleus. All You NEED in an RTOS. Royalty Free __________________________________________________________________ ----- Original Message ----- From: Baker, Dennis (sjmr) <DBaker@CHW.edu> To: <zope@zope.org> Sent: Thursday, March 30, 2000 5:05 PM Subject: [Zope] How do I download the results of a large Query I would like to set up a link to some SQL query results in comma delimited ascii that will download the data rather than display it. I am having two problems. First the data is coming up in the browser and I want them to download it without having to right click and select download. Second, before the SQL is completed the browser times out. I think if I solve the first problem, the second will be Ok, Any ideas? Dennis Baker Information Systems Manager, St. Joseph's Medical Resources _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (2)
-
Baker, Dennis (sjmr) -
Jim Sanford