Update the current page after downloading a file from a database

[Roger Withnell]

The current page has:

Response.Write "<a href=""FileDownload.asp?FileNo=" & UbeRS("FileNo") &
""">Down</a>"

FileDownload.asp has:
..
'Update downloaded file status in ubMgtFiles
UbeQ = "UPDATE ubMgtFiles SET Uploaded = NULL, Downloaded = GetDate(),
DownBy = " & Session("StaffNo")
UbeQ = ubeQ & " WHERE FileNo = " & vFileNo
objConn.Execute ubeQ
'Download file
UbeQ = "SELECT FileName, FileFile FROM UbMgtFiles WHERE FileNo = " & vFileNo
UbeRS.Open UbeQ, objConn,,, adCmdText
Response.Expires = 0
Response.Buffer = TRUE
Response.Clear
Response.ContentType = "application/x-msdownload"
Response.AddHeader "Content-Disposition", "inline;filename=" &
UbeRS("FileName")
Response.BinaryWrite UbeRS("FileFile")
Response.End

The database updates and the file downloads, but I now want to refresh the
current page to display the new file status (ie downloaded when and by
whom). How do I do this?

Thanking you in anticipation.

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

[StreamLogic]

Hi Roger,

Will a Response.Redirect or Server.Transfer not do the trick?

Curtis Hughes
StreamLogic Inc.
http://www.StreamLogicInc.com

Roger Withnell wrote:

The current page has:

Response.Write "<a href=""FileDownload.asp?FileNo=" & UbeRS("FileNo") &
""">Down</a>"

FileDownload.asp has:
.
'Update downloaded file status in ubMgtFiles
UbeQ = "UPDATE ubMgtFiles SET Uploaded = NULL, Downloaded = GetDate(),
DownBy = " & Session("StaffNo")
UbeQ = ubeQ & " WHERE FileNo = " & vFileNo
objConn.Execute ubeQ
'Download file
UbeQ = "SELECT FileName, FileFile FROM UbMgtFiles WHERE FileNo = " & vFileNo
UbeRS.Open UbeQ, objConn,,, adCmdText
Response.Expires = 0
Response.Buffer = TRUE
Response.Clear
Response.ContentType = "application/x-msdownload"
Response.AddHeader "Content-Disposition", "inline;filename=" &
UbeRS("FileName")
Response.BinaryWrite UbeRS("FileFile")
Response.End

The database updates and the file downloads, but I now want to refresh the
current page to display the new file status (ie downloaded when and by
whom). How do I do this?

Thanking you in anticipation.

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

[Roger Withnell]

Afraid not. If I put response.redirect before the response.end the upload
doesn't start. If I put it after the response.end it is ignored. If I remove
the response.end the upload doesn't start.

"StreamLogic" <co**********@streamlogicinc.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...

Hi Roger,

Will a Response.Redirect or Server.Transfer not do the trick?

Curtis Hughes
StreamLogic Inc.
http://www.StreamLogicInc.com

Roger Withnell wrote:

>The current page has:

Response.Write "<a href=""FileDownload.asp?FileNo=" & UbeRS("FileNo") &
""">Down</a>"

FileDownload.asp has:
.
'Update downloaded file status in ubMgtFiles
UbeQ = "UPDATE ubMgtFiles SET Uploaded = NULL, Downloaded = GetDate(),
DownBy = " & Session("StaffNo")
UbeQ = ubeQ & " WHERE FileNo = " & vFileNo
objConn.Execute ubeQ
'Download file
UbeQ = "SELECT FileName, FileFile FROM UbMgtFiles WHERE FileNo = " &
vFileNo
UbeRS.Open UbeQ, objConn,,, adCmdText
Response.Expires = 0
Response.Buffer = TRUE
Response.Clear
Response.ContentType = "application/x-msdownload"
Response.AddHeader "Content-Disposition", "inline;filename=" &
UbeRS("FileName")
Response.BinaryWrite UbeRS("FileFile")
Response.End

The database updates and the file downloads, but I now want to refresh
the
current page to display the new file status (ie downloaded when and by
whom). How do I do this?

Thanking you in anticipation.

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com