Layout and ASP with DB

[Mike]

Hello all,

I have a question, here is my situation. I am using a SQL
Server database and ASP to display the front page of a
website. Now this front page is generated from the
content of the database, it is an article management
system. When users go to the front page, they will see
all the articles that exist in the database, the titles
and 100 characters of the body only, so if they click the
title or the body, it opens up the entire article in
another window. Now this frontpage has a two column
layout ex:

title1 title2
body2 body2

Here is where the problem exist, if I have three articles
how can I display it like this:

title1 title2
body1 body2

title3
body3

Should I use x=mod/2, if x =0 then print to the right,
else print to the left or something similiar? How would I
account the empty column where title4 and body4 should be?

Do you count the articles first then based on the number
of articles divide it by 2 or what? Any and all help
would be appreciated.

[Aaron Bertrand [MVP]]

Use mod within your loop. You shouldn't have to adjust this code very much
to fit your needs:
[url]http://www.aspfaq.com/2247[/url]





"Mike" <anonymous@discussions.microsoft.com> wrote in message
news:001501c3a7a5$8bf27130$a301280a@phx.gbl...

> Hello all,
>
> I have a question, here is my situation. I am using a SQL
> Server database and ASP to display the front page of a
> website. Now this front page is generated from the
> content of the database, it is an article management
> system. When users go to the front page, they will see
> all the articles that exist in the database, the titles
> and 100 characters of the body only, so if they click the
> title or the body, it opens up the entire article in
> another window. Now this frontpage has a two column
> layout ex:
>
> title1 title2
> body2 body2
>
> Here is where the problem exist, if I have three articles
> how can I display it like this:
>
> title1 title2
> body1 body2
>
> title3
> body3
>
> Should I use x=mod/2, if x =0 then print to the right,
> else print to the left or something similiar? How would I
> account the empty column where title4 and body4 should be?
>
> Do you count the articles first then based on the number
> of articles divide it by 2 or what? Any and all help
> would be appreciated.

[William Tasso]

Mike wrote:

>...
> Here is where the problem exist, if I have three articles
> how can I display it like this:
>
> title1 title2
> body1 body2
>
> title3
> body3
>
> Should I use x=mod/2, if x =0 then print to the right,
> else print to the left or something similiar? How would I
> account the empty column where title4 and body4 should be?
>
> Do you count the articles first then based on the number
> of articles divide it by 2 or what? Any and all help
> would be appreciated.

This seems like a CSS question:

div.artical{
float:left;
width:48%;
}

--
William Tasso - [url]http://WilliamTasso.com[/url]

[Mike]

Excellent, thanks!

>-----Original Message-----
>Use mod within your loop. You shouldn't have to adjust

this code very much

>to fit your needs:
>[url]http://www.aspfaq.com/2247[/url]
>
>
>
>
>
>"Mike" <anonymous@discussions.microsoft.com> wrote in

message

>news:001501c3a7a5$8bf27130$a301280a@phx.gbl...

>> Hello all,
>>
>> I have a question, here is my situation. I am using a

SQL

>> Server database and ASP to display the front page of a
>> website. Now this front page is generated from the
>> content of the database, it is an article management
>> system. When users go to the front page, they will see
>> all the articles that exist in the database, the titles
>> and 100 characters of the body only, so if they click

the

>> title or the body, it opens up the entire article in
>> another window. Now this frontpage has a two column
>> layout ex:
>>
>> title1 title2
>> body2 body2
>>
>> Here is where the problem exist, if I have three

articles

>> how can I display it like this:
>>
>> title1 title2
>> body1 body2
>>
>> title3
>> body3
>>
>> Should I use x=mod/2, if x =0 then print to the right,
>> else print to the left or something similiar? How

would I

>> account the empty column where title4 and body4 should

be?

>>
>> Do you count the articles first then based on the number
>> of articles divide it by 2 or what? Any and all help
>> would be appreciated.

>
>
>.
>