return recordset of images in specific cells in a table

[David Shorthouse]

Hello folks,

I have an interesting problem and am looking for some advice. I am
hoping to build an asp whereby records are pulled from SQL Server. These
records will be merely file locations for thumbnail images I hope to display
in a grid. Rather than having a grid be constructed row-to-row, I was
wondering if it is at all possible to dynamically construct this grid as a
table of thumbnails whereby each cell (perhaps 5-6 columns across)
represents one record? I have no idea how one would construct this loop that
spans columns AND rows rather than just rows.

Thanks for any ideas,

Dave

--
______________________________
Remove "_SPAM" to reply directly.

[Adrienne]

Gazing into my crystal ball I observed "David Shorthouse"
<davidshorthouse@shaw_SPAM.ca> writing in
news:eJ**************@TK2MSFTNGP14.phx.gbl:

Hello folks,

I have an interesting problem and am looking for some advice. I am
hoping to build an asp whereby records are pulled from SQL Server.
These records will be merely file locations for thumbnail images I hope
to display in a grid. Rather than having a grid be constructed
row-to-row, I was wondering if it is at all possible to dynamically
construct this grid as a table of thumbnails whereby each cell (perhaps
5-6 columns across) represents one record? I have no idea how one would
construct this loop that spans columns AND rows rather than just rows.

Thanks for any ideas,

Dave

Do something like:

<% columns = 5 'how many columns do you want?%>
<table summary="thumbnail gallery">
<tbody>
<% 'get the records
'start a loop
counter = counter + 1
imgsrc = rs(fieldvalue)
desc = rs(description of image if there is one) %>
<td><img src="<%=imgsrc%>" alt="<%=desc%>"></td>
<% rs.Movenext
if columns mod counter = 0 then
%>
</tr>
<% if not rs.EOF then%>
<tr>
<% end if%>
<% end if %>
</tbody>
</table>

--
Adrienne Boswell
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

[David Shorthouse]

Thanks! I'll give it a go.

Dave

--
______________________________
Remove "_SPAM" to reply directly.

Hello folks,

I have an interesting problem and am looking for some advice. I am
hoping to build an asp whereby records are pulled from SQL Server.
These records will be merely file locations for thumbnail images I hope
to display in a grid. Rather than having a grid be constructed
row-to-row, I was wondering if it is at all possible to dynamically
construct this grid as a table of thumbnails whereby each cell (perhaps
5-6 columns across) represents one record? I have no idea how one would
construct this loop that spans columns AND rows rather than just rows.

Thanks for any ideas,

Dave

Do something like:

<% columns = 5 'how many columns do you want?%>
<table summary="thumbnail gallery">
<tbody>
<% 'get the records
'start a loop
counter = counter + 1
imgsrc = rs(fieldvalue)
desc = rs(description of image if there is one) %>
<td><img src="<%=imgsrc%>" alt="<%=desc%>"></td>
<% rs.Movenext
if columns mod counter = 0 then
%>
</tr>
<% if not rs.EOF then%>
<tr>
<% end if%>
<% end if %>
</tbody>
</table>

--
Adrienne Boswell
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

[David Shorthouse]

Adrienne,

It was a good start, but doesn't work. Any chance you can scrutinize your
code again. In particular, I don't know where to put the "loop". The result
of your code is one column of images instead of being spread across columns
and rows.

Thanks for any additional suggestions,

Dave
______________________________
Remove "_SPAM" to reply directly.
"Adrienne" <ar********@sbcglobal.net> wrote in message
news:Xn****************************@207.115.63.158 ...

Gazing into my crystal ball I observed "David Shorthouse"
<davidshorthouse@shaw_SPAM.ca> writing in
news:eJ**************@TK2MSFTNGP14.phx.gbl:

Hello folks,

I have an interesting problem and am looking for some advice. I am
hoping to build an asp whereby records are pulled from SQL Server.
These records will be merely file locations for thumbnail images I hope
to display in a grid. Rather than having a grid be constructed
row-to-row, I was wondering if it is at all possible to dynamically
construct this grid as a table of thumbnails whereby each cell (perhaps
5-6 columns across) represents one record? I have no idea how one would
construct this loop that spans columns AND rows rather than just rows.

Thanks for any ideas,

Dave

Do something like:

<% columns = 5 'how many columns do you want?%>
<table summary="thumbnail gallery">
<tbody>
<% 'get the records
'start a loop
counter = counter + 1
imgsrc = rs(fieldvalue)
desc = rs(description of image if there is one) %>
<td><img src="<%=imgsrc%>" alt="<%=desc%>"></td>
<% rs.Movenext
if columns mod counter = 0 then
%>
</tr>
<% if not rs.EOF then%>
<tr>
<% end if%>
<% end if %>
</tbody>
</table>

--
Adrienne Boswell
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

[David Shorthouse]

Adrienne,

Got it all fixed-up and works a treat now.

Dave

--
______________________________
Remove "_SPAM" to reply directly.
"Adrienne" <ar********@sbcglobal.net> wrote in message
news:Xn****************************@207.115.63.158 ...

Gazing into my crystal ball I observed "David Shorthouse"
<davidshorthouse@shaw_SPAM.ca> writing in
news:eJ**************@TK2MSFTNGP14.phx.gbl:

Hello folks,

I have an interesting problem and am looking for some advice. I am
hoping to build an asp whereby records are pulled from SQL Server.
These records will be merely file locations for thumbnail images I hope
to display in a grid. Rather than having a grid be constructed
row-to-row, I was wondering if it is at all possible to dynamically
construct this grid as a table of thumbnails whereby each cell (perhaps
5-6 columns across) represents one record? I have no idea how one would
construct this loop that spans columns AND rows rather than just rows.

Thanks for any ideas,

Dave

Do something like:

<% columns = 5 'how many columns do you want?%>
<table summary="thumbnail gallery">
<tbody>
<% 'get the records
'start a loop
counter = counter + 1
imgsrc = rs(fieldvalue)
desc = rs(description of image if there is one) %>
<td><img src="<%=imgsrc%>" alt="<%=desc%>"></td>
<% rs.Movenext
if columns mod counter = 0 then
%>
</tr>
<% if not rs.EOF then%>
<tr>
<% end if%>
<% end if %>
</tbody>
</table>

--
Adrienne Boswell
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

[Adrienne]

Gazing into my crystal ball I observed "David Shorthouse"
<davidshorthouse@shaw_SPAM.ca> writing in news:eZ#MnRefFHA.1148
@TK2MSFTNGP12.phx.gbl:

Adrienne,

Got it all fixed-up and works a treat now.

Dave

Glad I was able to help. It works for printing labels, too.

--
Adrienne Boswell
http://www.cavalcade-of-coding.info
Please respond to the group so others can share