[Zope] How do I download the results of a large Query

[Jim Sanford]

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 )