[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