Calendar / Album style resultset

[Adam]

Hello everyone,

I am trying to make my result set print out the results in the same style as
a calendar or photo album. I am actually making a photo album, and I can
only print the results in list format. I would like to have 3 or 4 results
per table row. Then once I have 3 or 4 results across a new row in the table
will start.

I can accomplish this:

Result 1

Result 2

Result 3

Result 4

Result 5

But I am trying to accomplish this:

Result 1
Result 2
Result 3

Result 4
Result 5

Obviously if the specific user had more than 5 results it would keep going..
result 6 result 7 result 8 etc etc.

With only 3 results per each table row..

I am really struggling with this one specific piece, and have never been
able to figure it out.

If anyone has any samples or knows how I can figure this out, I really need
to know.

Thanks in advance!

-Adam

[Steven Burn]

'// Initial table
<table border="0">

If Count = 3 Then
%>
</table>
<table border="0">
<%
Count = 0
Else
Response.Write "<tr><td>" & rst("whatever") & "</td></tr>"
Count = Count + 1
End If

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!
"Adam" <ad*****@sharklogic.com> wrote in message
news:Az***************@news20.bellglobal.com...

Hello everyone,

I am trying to make my result set print out the results in the same style as a calendar or photo album. I am actually making a photo album, and I can
only print the results in list format. I would like to have 3 or 4 results
per table row. Then once I have 3 or 4 results across a new row in the table will start.

I can accomplish this:

Result 1

Result 2

Result 3

Result 4

Result 5

But I am trying to accomplish this:

Result 1
Result 2
Result 3

Result 4
Result 5

Obviously if the specific user had more than 5 results it would keep going.. result 6 result 7 result 8 etc etc.

With only 3 results per each table row..

I am really struggling with this one specific piece, and have never been
able to figure it out.

If anyone has any samples or knows how I can figure this out, I really need to know.

Thanks in advance!

-Adam

[Aaron Bertrand - MVP]

http://www.aspfaq.com/2247

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Adam" <ad*****@sharklogic.com> wrote in message
news:Az***************@news20.bellglobal.com...

Hello everyone,

I am trying to make my result set print out the results in the same style as a calendar or photo album. I am actually making a photo album, and I can
only print the results in list format. I would like to have 3 or 4 results
per table row. Then once I have 3 or 4 results across a new row in the table will start.

I can accomplish this:

Result 1

Result 2

Result 3

Result 4

Result 5

But I am trying to accomplish this:

Result 1
Result 2
Result 3

Result 4
Result 5

Obviously if the specific user had more than 5 results it would keep going.. result 6 result 7 result 8 etc etc.

With only 3 results per each table row..

I am really struggling with this one specific piece, and have never been
able to figure it out.

If anyone has any samples or knows how I can figure this out, I really need to know.

Thanks in advance!

-Adam

[Adam]

Thanks for the help, I managed to put some weird piece of code together and
figured it out.

I will try the provided aspfaq example, and get back with my version - it is
similiar to the first reply.

Thanks again!!

"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message
news:eU**************@TK2MSFTNGP11.phx.gbl...

http://www.aspfaq.com/2247

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Adam" <ad*****@sharklogic.com> wrote in message
news:Az***************@news20.bellglobal.com...

Hello everyone,

I am trying to make my result set print out the results in the same style

as

a calendar or photo album. I am actually making a photo album, and I can
only print the results in list format. I would like to have 3 or 4

results per table row. Then once I have 3 or 4 results across a new row in the

table

will start.

I can accomplish this:

Result 1

Result 2

Result 3

Result 4

Result 5

But I am trying to accomplish this:

Result 1
Result 2
Result 3

Result 4
Result 5

Obviously if the specific user had more than 5 results it would keep

going..

result 6 result 7 result 8 etc etc.

With only 3 results per each table row..

I am really struggling with this one specific piece, and have never been
able to figure it out.

If anyone has any samples or knows how I can figure this out, I really

need

to know.

Thanks in advance!

-Adam