Displaying Images

<i><b>Originally posted by : max (shawn@speaketh.com)</b></i><br />Hiya <br /><br />I am trying to post images onto webpages using ASP. <br />After the user search thru the database, 2 images(1 image for 1 record) will be displayed to one page(thus having 2 record display on one page)...and you can page thru the record(so if the search generate 10 record, you can page thru 5 pages). <br /><br />The thing now is the images displayed are both same. Let say there are 6 records -mouse, keyboard, scanner, monitor, ram, zip drive. The first page should display images of mouse and keyboard. But both the images displayed are mouse. And the second page displayed 2 images of scanner instead of image of scanner and monitor. <br /><br />Please help. <br /><br />here are the code I use: <br /><img src="<% =rst("Image") %>" width="330" height="400" <br />alt="<% =rst("Image") %>" align="left"><img src="<% =rst("Image") %>" width="330" height="400" <br />alt="<% =rst("Image") %>" align="left"> <br /><br />while the paging mechanism I just specify the pagesize. <br /><br />Thanx a million! <br /><br />

<i><b>Originally posted by : steve schofield</b></i><br />http://www.aspfree.com/asp/questionwinner2.asp?id=14 here is a link to displaying images out of a sql 7 db. I understand you want to based on which image this is which gif is displayed to the user. Being a db person I'd have a column that indicates which type of image this is. Then when writing out the record you could test for that in your recordset and based on that which image to be displayed..<br /><br />steve<br /><br />------------<br />max at 2/10/2000 9:17:59 PM<br /><br />Hiya <br /><br />I am trying to post images onto webpages using ASP. <br />After the user search thru the database, 2 images(1 image for 1 record) will be displayed to one page(thus having 2 record display on one page)...and you can page thru the record(so if the search generate 10 record, you can page thru 5 pages). <br /><br />The thing now is the images displayed are both same. Let say there are 6 records -mouse, keyboard, scanner, monitor, ram, zip drive. The first page should display images of mouse and keyboard. But both the images displayed are mouse. And the second page displayed 2 images of scanner instead of image of scanner and monitor. <br /><br />Please help. <br /><br />here are the code I use: <br /><img src="<% =rst("Image") %>" width="330" height="400" <br />alt="<% =rst("Image") %>" align="left"><img src="<% =rst("Image") %>" width="330" height="400" <br />alt="<% =rst("Image") %>" align="left"> <br /><br />while the paging mechanism I just specify the pagesize. <br /><br />Thanx a million! <br /><br />