Hello,

This is Zeeshan Ahmed from itHighway. I have an application with my sql database containing about 30000 members records. There are 120 fields for in members table.


I have developed a script to download members data in CSV file but the problem is it only download only 800, 1000 or 1200 members records and after that the download is terminated.

I need to download all 30000 records in CSV file. Is there any solution to the issue I am having?

At the end of this post I have posted a few important lines from my download script.

Any idea..
Any help..
Will really be appriciated..


Thank you
Zeeshan Ahmed
itHighway


================================================== ======
================================================== ======
================================================== ======
Response.Expires = 0
server.ScriptTimeout = 1000
Response.Buffer = false

Response.ContentType = "text/csv"
Response.AddHeader "Content-Disposition", "attachment;filename=Members.csv"


set rAdmin = CONN.execute("SELECT * FROM MEMBERS")


txtA = "Phone Number,E-mail,Name,Street,"
response.Write(txtA)

txtA = "Info1,Info2,Info3,Info4,Info5,Info6,"
response.Write(txtA)
...................
............................

do while NOT rAdmin.EOF

    txtB = ""& rAdmin("PHONE_NUMBER")
    txtB = txtB + ","& rAdmin("EMAIL")
    txtB = txtB + ","& rAdmin("NAME")
    txtB = txtB + ","& rAdmin("STREET")
    response.Write(txtB)
        ...................
        ............................

rAdmin.MoveNext
loop

__________________
Zeeshan Dar
itHighway
web design development, property management software & web based real estate listings software services provider