[thelist] ASP image database reteval

Keni Barwick keni at barwick.net
Wed Mar 7 07:15:42 CST 2001


I am having tuns of trouble with this code. I am trying to place an image into a page, the image is being serverd by a database.

<%
Response.Expires = 0
Response.Buffer = TRUE
Response.Clear
Response.ContentType="image/gif"
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "DSN=WorkDB"
SQLB = "SELECT fldVisuals FROM tblWorkVisuals WHERE fldCompanyName= "
SQLB = SQLB & Request("workTitle")
Set rsImage = Connection.Execute(SQLB)
Response.BinaryWrite rsImage("fldVisuals")
Response.End
%>

but its not having any of it!!

Any takers?






More information about the thelist mailing list