[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