Click here to Skip to main content
15,914,608 members
Home / Discussions / Web Development
   

Web Development

 
AnswerThe no answer board....I guess Pin
srt79-Apr-04 3:55
srt79-Apr-04 3:55 
AnswerRe: How to put a Search Engine on a website Pin
John Kuhn9-Apr-04 16:25
John Kuhn9-Apr-04 16:25 
Generalproblem in debugging ISAPI dll. Pin
suvarna joshi8-Apr-04 2:16
suvarna joshi8-Apr-04 2:16 
GeneralNeed CAB-file tutorial… and ActiveX-help Pin
anderslundsgard7-Apr-04 5:02
anderslundsgard7-Apr-04 5:02 
GeneralASP FILE NOT CORRECT Pin
Brendan Vogt6-Apr-04 21:23
Brendan Vogt6-Apr-04 21:23 
GeneralCLIENT-SIDED VALIDATION NEEDED Pin
Brendan Vogt6-Apr-04 21:21
Brendan Vogt6-Apr-04 21:21 
GeneralRe: CLIENT-SIDED VALIDATION NEEDED Pin
alex.barylski9-Apr-04 19:07
alex.barylski9-Apr-04 19:07 
GeneralViewing uploaded file from SQL Server Pin
vj_asu6-Apr-04 6:25
vj_asu6-Apr-04 6:25 
Hi All,

I am able to upload the files to the SQL Server 2000 using SA FileUp Component. Now I would like to view the uploaded file from the client machine and also I want to provide the users to save that uploaded file in their local machine. I had tried the following piece of code to do that, but no luck so far. It is writing the content in browser window with some invalid characters except for the text file. Could any of you please help me with this?

Dim MSCS, Rs, strSQL
Set MSCS= Server.CreateObject("ADODB.Connection")
MSCS.ConnectionTimeout = 90
MSCS.Open "Provider=SQLOLEDB;data Source=server_name;Initial Catalog=db_name;User Id=user_id;Password=pwd"
Set Rs = Server.CreateObject ("ADODB.Recordset")
'strSQL = "SELECT * FROM tbl_test_upload WHERE file_id = " & request("id")
Rs.Open strSQL, MSCS, 2, 3
Response.ContentType = Rs("file_type")
Response.AddHeader "Content-Disposition", "filename=" & Rs("file_name")
Response.BinaryWrite Rs("file_data")
Rs.close

Thanks.

vijay
GeneralRe: Viewing uploaded file from SQL Server Pin
Hesham Amin6-Apr-04 21:29
Hesham Amin6-Apr-04 21:29 
Generalhtml text wrapping Pin
harinath5-Apr-04 19:37
professionalharinath5-Apr-04 19:37 
GeneralRe: html text wrapping Pin
Roger Wright5-Apr-04 19:52
professionalRoger Wright5-Apr-04 19:52 
GeneralRe: html text wrapping Pin
harinath5-Apr-04 20:04
professionalharinath5-Apr-04 20:04 
GeneralRe: html text wrapping Pin
superwinsock7-Apr-04 20:08
superwinsock7-Apr-04 20:08 
GeneralRe: html text wrapping Pin
harinath7-Apr-04 22:03
professionalharinath7-Apr-04 22:03 
GeneralHttpRequest in Opera browser Pin
MurthyPL5-Apr-04 5:39
MurthyPL5-Apr-04 5:39 
GeneralRe: HttpRequest in Opera browser Pin
John Kuhn9-Apr-04 17:41
John Kuhn9-Apr-04 17:41 
GeneralUpdating of SQL Database with JavaScript/VBScript in .NET Pin
ebirien4-Apr-04 23:15
ebirien4-Apr-04 23:15 
GeneralEmailing a Form and Post Data to Access Pin
eyespike14-Apr-04 4:27
eyespike14-Apr-04 4:27 
GeneralTemp Internet Files Pin
3-Apr-04 7:29
suss3-Apr-04 7:29 
GeneralRe: Temp Internet Files Pin
hxxbin6-Apr-04 4:42
hxxbin6-Apr-04 4:42 
Generalunwanted javascript behavior Pin
harinath3-Apr-04 3:34
professionalharinath3-Apr-04 3:34 
GeneralRestricting User to View page after log out Pin
Kuldeep Bhatnagar2-Apr-04 21:22
Kuldeep Bhatnagar2-Apr-04 21:22 
GeneralQuerystring.Request using JavaScript or VBScript on an HTML page Pin
rdewell2-Apr-04 5:44
rdewell2-Apr-04 5:44 
GeneralRe: Querystring.Request using JavaScript or VBScript on an HTML page Pin
hxxbin6-Apr-04 4:33
hxxbin6-Apr-04 4:33 
GeneralOptimization matter?! Pin
benqazou2-Apr-04 4:50
benqazou2-Apr-04 4:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.