Retrieving multiple images from SQL 2000

FamyImpanda

New Member
Hi all,<BR> I'm trying to output multiple images that are held in an SQL image field. The essential code is:<BR><BR>While (myDataReader.Read())<BR>&nbsp;&nbsp;Response.ContentType = myDataReader.Item("imageType") <BR>&nbsp;&nbsp;Response.BinaryWrite(myDataReader.Item("imageName"))<BR>end while<BR><BR>doesn't proceed to the next record and print out another image. I know that more than one record is being returned, but I can't work out how to alter this code to deal with multiple images. <BR><BR>All help is definately appreciated<BR><BR>Chris
 
Back
Top