Adobe Community: Display Image From Stored Procedure

bake1234 Calculating status...

Currently Being Moderated

Display Image From Stored Procedure

Jun 15, 2012 10:41 AM

Tags: #problem #help #display #database #coding

I have a SQL query in a .ASP page using a stored procedure:

<%
sql="exec fp_qr_code '" & request.querystring("id") & "'"
set rs = Conn.Execute(sql)
if rs.eof then response.write("No Records")
while not rs.eof
response.write (rs("name"))

response.write (rs("imgname"))

response.write (rs("url"))

rs.movenext
wend
%>

When viewed in a browser, it displays all of the variables properly. But what I need to do is display the actual image from:

response.write (rs("imgname"))

All it does is writes the name of the image.

I tried <img src=<% response.write(session("imgname")) %> but that renders a 500 server error.

I have Googled this to death but can't seem to find a solution. Any help would be most appreciated.

221 Views 0 Replies

Develop server-side applications in Dreamweaver

Display Image From Stored Procedure

Jun 15, 2012 10:41 AM

More Like This

Bookmarked By (0)

Answers + Points = Status