Binary BLOB data

Results 1 to 2 of 2

Thread: Binary BLOB data

  1. #1
    Join Date
    Dec 1969

    Default Binary BLOB data

    I hava blob/binary data column on SQL 7.0 i upload word and pdf<BR>as binary now i like to download them to the client browser on the file anyone know a code the one i have is downloada binary<BR>like below code<BR>Response.Buffer = True<BR> <BR> Dim Conn,rs,MySQL,strdocument<BR> <BR> X = Request.QueryString("ID")<BR> <BR> Set Conn = Server.CreateObject("ADODB.Connection")<BR> <BR> Set rs = Server.CreateObject("adodb.recordset")<BR> Conn.Open"DRIVER=SQL SERVER;;database =EStudio;UID=merrill;pwd=merrill;"<BR> <BR> MySQL = "Select FILECOL FROM UploadTable Where ID=" & X<BR> MySQL,Conn<BR> <BR> &#039strDocument = rs.Fields(0).Value <BR> <BR> strDocument = rs.Fields("FILECOL")<BR> Response.ContentType ="application/pdf"<BR> Response.BinaryWrite strDocument<BR>puts on browser binary<BR>thanks for help

  2. #2
    Join Date
    Dec 1969

    Default clairification needed

    Does the code that you included not work? What is the error? Please try to use complete sentences with punctuation and all. I could not follow your post at all.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts