Wrox Programmer Forums
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old May 10th, 2008, 11:39 AM
Registered User
Join Date: Dec 2007
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to may29adil Send a message via Yahoo to may29adil
Default Download Problem From Db

i am using SQL db 2000 made a function upload song and they store into my db as a binary format i my computer songs are uploading fine and downloading fine too but when i upload this data into my server i can upload the songs but unable to download the songs

for the download i use this code

sql="select from tblsong where songid=32"
set rec=con.execute(sql)
if rec.eof=true then

Response.AddHeader "content-disposition", "attachment; filename=" & rec("Song_name")& "." & Rec("song_ext")
'Response.AddHeader "content-disposition", "inline; filename=" & rec("song_name") & "." & Rec("song_ext")
Response.AddHeader "content-length", Rec("song").ActualSize
Response.ContentType = Rec("song_ext")

Response.BinaryWrite Rec("song")
end if

my binary datafield is type is IMAGE

so please tell me wht is the problem


Similar Threads
Thread Thread Starter Forum Replies Last Post
FTP Download Problem JohnEw Pro VB 6 0 September 4th, 2006 09:57 AM
forcing files to download problem harpua Classic ASP Professional 2 July 4th, 2006 09:45 AM
download code problem smartintellegentguy J2EE 0 February 16th, 2005 02:41 AM
File download problem sandeep_chalke .NET Web Services 0 June 24th, 2004 12:20 PM
download db data to .xls with asp abbylee26 Classic ASP Databases 2 October 17th, 2003 02:18 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.