[thelist] ASP image database reteval
Ryan Mayberry
Ryan at applicor.com
Wed Mar 7 09:52:57 CST 2001
I'm not an ASP expert by any means.. but something looks wrong to me in this
line..
SQLB = "SELECT fldVisuals FROM tblWorkVisuals WHERE fldCompanyName= "
I would think you need to give fldCompanyName a value which it needs to
match. If the value is left blank, which it looks like it is, your SQL query
won't pull any results.
kerkness..
-----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!!
Any takers?
---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !
More information about the thelist
mailing list