query results 1

[mimi2]

hello, i am trying to use ASP for something that can't be done in coldfusion: displaying blob objects.
for a single id, i can have 3 images.
is there a way i could loop to display the 3 objects using the following code (that i copied somewhere)
thanks.

<%
Dim oConn
Dim oRS
Dim icolpo

Response.Expires=0
Response.Buffer=True
Response.Clear

Response.contentType = &quot;image/tif&quot;

Set oConn = Server.CreateObject(&quot;ADODB.Connection&quot
oConn.Open &quot;Provider=SQEDB;User ID=someone; Password=someone; Initial Catalog=Test;Data
Source=DBTest&quot;
IF Request.QueryString =&quot;&quot; THEN
Response.Write &quot;nothing&quot;
ELSE

Set oRS = Server.CreateObject(&quot;ADODB.Recordset&quot
oRs.Open &quot; SELECT image&quot; & _
&quot; FROM DB1 d JOIN DB2 i
on i.id = d.id&quot; & _
&quot; WHERE i.second_id = &quot; & _
Request.QueryString(&quot;second_id&quot, oConn


Response.BinaryWrite oRS(&quot;image&quot

Response.end

END IF

'Close the recordset
oRS.Close
SET oRS = Nothing

'Close the connection
oConn.Close
Set oConn = Nothing

%>

 

[rac2]

While Not oRS.EOF
Response.BinaryWrite oRS(&quot;image&quot
oRS.MoveNext
Wend

 

[mimi2]

Thanks. I got an answer from another forum saying that is not possible when blobs are stored in the database !

 

[rac2]

My apologies. On experimenting I find that MoveNext does not seem to work with a recordset that includes a BLOB.

In fact diplaying an image seems to require rather a lot of steps.

Sorry about that mistaken reply.

 

[snowboardr]

Why blob? why not use image link? =/ www.vzio.com

if I helped.