How does one obtain two columns of row on a single asp page?

[Jack]

Hi,
I have a query result as follows:

State ScSortOrder SlCity SclAdd SlPhone SlKey SlHdFNm
SlHdLNm SlHdSortOrder SlHdPhNo

NY 1 Albany 200 Dee Drive 444-4444 1200 Carol
Hunt 1 444-4441
NY 1 Albany 200 Dee Drive 444-4444 1200 Jack Foster
2 444-4442
NY 1 Albany 200 Dee Drive 444-4444 1200
Hoffman 3 444-4443
NY 2 Yonkers 100 X Drive 999-9999 1250 Jonny
Walker 1 999-9991
NY 3 Bronx 400 Y Drive 111-1111 1260 James
Jones 1 999-9992

I have to use the above query to build a HTML page using asp. However, the
output
need to be in two column(covering the whole page as shown below). The format
of the output would be as shown below.

My questions is: How does one bring the above query result in two columns in
asp output.
How does one force a break i.e. instead of one column the output shows in
two columns.
No idea. Any help or advise is highly appreciated. Thanks in advance.



The final output would be as follows


Albany(in bold) Yonkers(in bold)

200 Dee Drive 100 x Drive
Phone: 444-4444 Phone: 999-9999

Carol Hunt Jonny Walker
Phone: 444-4441 Phone: 999-9991

Jack Foster
Phone: 444-4442 Bronx(in bold)

Hoffman 400 Y Drive
Phone: 444-4443 Phone:111-1111

James Jones
Phone: 111-1112

 

[Bob Barrows [MVP]]

Hi,
I have a query result as follows:

State ScSortOrder SlCity SclAdd SlPhone SlKey
SlHdFNm SlHdLNm SlHdSortOrder SlHdPhNo

NY 1 Albany 200 Dee Drive 444-4444 1200
Carol Hunt 1 444-4441
NY 1 Albany 200 Dee Drive 444-4444 1200 Jack
Foster 2 444-4442
NY 1 Albany 200 Dee Drive 444-4444 1200
Hoffman 3 444-4443
NY 2 Yonkers 100 X Drive 999-9999 1250 Jonny
Walker 1 999-9991
NY 3 Bronx 400 Y Drive 111-1111 1260 James
Jones 1 999-9992

I have to use the above query to build a HTML page using asp.
However, the output
need to be in two column(covering the whole page as shown below). The
format of the output would be as shown below.

My questions is: How does one bring the above query result in two
columns in asp output.
How does one force a break i.e. instead of one column the output
shows in two columns.
No idea. Any help or advise is highly appreciated. Thanks in advance.



The final output would be as follows


Albany(in bold) Yonkers(in bold)

Create an html page that displays the data as you desire it. Then modify
your asp code to output the correct html.
If you need help in creating the html, then you need to followup in a
newsgroup devoted to html.

Bob Barrows

 

[Aaron [SQL Server MVP]]

http://www.aspfaq.com/2247

 

[Dave Anderson]

My questions is: How does one bring the above query result in two
columns in asp output.
How does one force a break i.e. instead of one column the output
shows in two columns.
No idea. Any help or advise is highly appreciated. Thanks in advance.

I'm not sure if this is qhat you are asking for, but CSS3 offers column
balancing through the column-span attribute:

http://www.w3.org/TR/2001/WD-css3-multicol-20010118/#column-span

I don't know of a browser that supports it, however.



--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

 

[Hal Rosser]

Hi,
I have a query result as follows:

State ScSortOrder SlCity SclAdd SlPhone SlKey SlHdFNm
SlHdLNm SlHdSortOrder SlHdPhNo

NY 1 Albany 200 Dee Drive 444-4444 1200 Carol
Hunt 1 444-4441
NY 1 Albany 200 Dee Drive 444-4444 1200 Jack Foster
2 444-4442
NY 1 Albany 200 Dee Drive 444-4444 1200
Hoffman 3 444-4443
NY 2 Yonkers 100 X Drive 999-9999 1250 Jonny
Walker 1 999-9991
NY 3 Bronx 400 Y Drive 111-1111 1260 James
Jones 1 999-9992

I have to use the above query to build a HTML page using asp. However, the
output
need to be in two column(covering the whole page as shown below). The format
of the output would be as shown below.

My questions is: How does one bring the above query result in two columns in
asp output.
How does one force a break i.e. instead of one column the output shows in
two columns.
No idea. Any help or advise is highly appreciated. Thanks in advance.



The final output would be as follows


Albany(in bold) Yonkers(in bold)

200 Dee Drive 100 x Drive
Phone: 444-4444 Phone: 999-9999

Carol Hunt Jonny Walker
Phone: 444-4441 Phone: 999-9991

Jack Foster
Phone: 444-4442 Bronx(in bold)

Use the <table> tag and its children, the <tr> and <td> tags in the output.
put your data inside the <td> tags