You're getting an IE error, but have shown a script that we are not going to
be able to run. This is not going to allow analysis.

What you need to provide is the HTML page that the script has generated. If
you can't get it from IE, you can get it from FF.

Regards, Dave S

----- Original Message -----
From: "Moshe Tapnack" <elists@...>
To: <active-server-pages@yahoogroups.com>
Sent: Wednesday, May 06, 2009 5:00 AM
Subject: [ASP] (push-)Downloading from IE


> Hey there
>
> I have a script that should download a CSV file from the browser. It works
> perfectly on Firefox and Chrome - but on IE(v7) it chokes and throws and
> error - "IE was not able to download the file..."
>
> In fact I have a similar issue at the moment, when downloading a JPG - the
> script first checks some database stuff, then retrieves the image from
> higher-than-the-root and pushes it to the user. Works like a charm in
> Firefox, but chokes in IE.
>
> any idea what it could be?
> ASP code attached.
>
> Thanks!
> Moshe
>
> <%
> sql = "SELECT ...."
> set rs = conn.execute(sql)
>
> if rs.eof then
> response.Write("No data available in this table")
> set rs = nothing
> else
> strReturn = ""
> for each field in rs.fields
> strReturn = strReturn & field.name & ","
> next
> strReturn = left(strReturn, len(strReturn)-1) 'remove last comma
> strReturn = strReturn & vbcr
>
> do while not rs.eof
> for each field in rs.fields
>
> fieldvalue = rs.fields(field.name) & ""
> fieldvalue = replace(fieldvalue, ","," ")
> fieldvalue = replace(fieldvalue, """","'")
> fieldvalue = replace(fieldvalue, "="," ")
>
> fieldvalue = replace(fieldvalue, vbCrLf," ")
> fieldvalue = replace(fieldvalue, vbCr," ")
> fieldvalue = replace(fieldvalue, chr(10)," ")
> fieldvalue = replace(fieldvalue, chr(13)," ")
>
> strReturn = strReturn & chr(34) & fieldvalue &
> chr(34) & ","
> next
> strReturn = left(strReturn, len(strReturn)-1)
> strReturn = strReturn & vbCrLf
> rs.movenext
> loop
>
>
>
> rs.Close
> set rs = Nothing
>
> server.ScriptTimeout = 18000
>
> Response.AddHeader "Content-Disposition", "attachment;
> filename=report-" & request.Cookies(ewProjectName)("programID") & "-" &
> exportTable&".csv"
>
> Response.Charset = "UTF-8"
> Response.ContentType = "text/csv"
> Response.Write strReturn
> Response.Flush
> Response.Clear
>
> %>
>
>
>
> ------------------------------------
>
> ---------------------------------------------------------------------
> Home : http://groups.yahoo.com/group/active-server-pages
> ---------------------------------------------------------------------
> Post : active-server-pages@yahoogroups.com
> Subscribe : active-server-pages-subscribe@yahoogroups.com
> Unsubscribe: active-server-pages-unsubscribe@yahoogroups.com
> ---------------------------------------------------------------------Yahoo!
> Groups Links
>
>
>