[thelist] ASP image database reteval

J J squid_66 at yahoo.com
Wed Mar 7 10:50:23 CST 2001


Make it easy on yourself, place this into one line:

SQLB = "SELECT fldVisuals FROM tblWorkVisuals WHERE
fldCompanyName= "
SQLB = SQLB & Request("workTitle")


like so:

SQLB = "SELECT fldVisuals FROM tblWorkVisuals WHERE
fldCompanyName = '" & Request("workTitle") & "'


James


> 
> -----Original Message-----
> From: Keni Barwick [mailto:keni at barwick.net]
> Sent: Wednesday, March 07, 2001 7:16 AM
> To: thelist at lists.evolt.org
> Subject: [thelist] ASP image database reteval
> 
> 
> 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!!
> 

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/




More information about the thelist mailing list