hello,
since it is impossible to view a blob object from a coldfusion application, i am trying to use asp for that (this is the first time i am doing that).
it is not working. could you tell why. thanks
<%
Dim oConn
Dim oRS
Dim icolpo
Response.Expires=0
Response.Buffer=True
Response.Clear
Response.contentType = "image/tif"
Set oConn = Server.CreateObject("ADODB.Connection"
oConn.Open "Provider=SQLOLEDB;User ID=someone; Password=someone; Initial Catalog=Test;Data
Source=DBTest"
IF Request.QueryString ="" THEN
Response.Write "nothing"
ELSE
Set oRS = Server.CreateObject("ADODB.Recordset"
oRs.Open " SELECT image" & _
" FROM DB1 d JOIN DB2 i
on i.d = d.id" & _
" WHERE i.second_id = " & _
Request.QueryString("second_id"
, oConn
Response.BinaryWrite oRS("image"
Response.end
END IF
'Close the recordset
oRS.Close
SET oRS = Nothing
'Close the connection
oConn.Close
Set oConn = Nothing
%>
since it is impossible to view a blob object from a coldfusion application, i am trying to use asp for that (this is the first time i am doing that).
it is not working. could you tell why. thanks
<%
Dim oConn
Dim oRS
Dim icolpo
Response.Expires=0
Response.Buffer=True
Response.Clear
Response.contentType = "image/tif"
Set oConn = Server.CreateObject("ADODB.Connection"
oConn.Open "Provider=SQLOLEDB;User ID=someone; Password=someone; Initial Catalog=Test;Data
Source=DBTest"
IF Request.QueryString ="" THEN
Response.Write "nothing"
ELSE
Set oRS = Server.CreateObject("ADODB.Recordset"
oRs.Open " SELECT image" & _
" FROM DB1 d JOIN DB2 i
on i.d = d.id" & _
" WHERE i.second_id = " & _
Request.QueryString("second_id"
Response.BinaryWrite oRS("image"
Response.end
END IF
'Close the recordset
oRS.Close
SET oRS = Nothing
'Close the connection
oConn.Close
Set oConn = Nothing
%>