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: [phone] Phone: [phone]

Carol Hunt Jonny Walker
Phone: [phone] Phone: [phone]

Jack Foster
Phone: [phone] Bronx(in bold)

Hoffman 400 Y Drive
Phone: [phone] Phone:[phone]

James Jones
Phone: [phone]

[Bob Barrows [MVP]]

Jack wrote:

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
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Curt_C [MVP]]

It's all a matter of looping through the result set. I usually set a
variable and do something like

if x = 1 then
Response.Write "</td><td>"
x = 0
else
x = 1
end if

That way you get the new cell for a parent table in every other row.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Jack" <Ja**@discussions.microsoft.com> wrote in message
news:08**********************************@microsof t.com...

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: [phone] Phone: [phone]

Carol Hunt Jonny Walker
Phone: [phone] Phone: [phone]

Jack Foster
Phone: [phone] Bronx(in bold)

Hoffman 400 Y Drive
Phone: [phone] Phone:[phone]

James Jones
Phone: [phone]

[Aaron [SQL Server MVP]]

http://www.aspfaq.com/2247

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Jack" <Ja**@discussions.microsoft.com> wrote in message
news:08**********************************@microsof t.com...

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: [phone] Phone: [phone]

Carol Hunt Jonny Walker
Phone: [phone] Phone: [phone]

Jack Foster
Phone: [phone] Bronx(in bold)

Hoffman 400 Y Drive
Phone: [phone] Phone:[phone]

James Jones
Phone: [phone]

[Dave Anderson]

Jack wrote:

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-mu...8/#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]

"Jack" <Ja**@discussions.microsoft.com> wrote in message
news:08**********************************@microsof t.com...

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: [phone] Phone: [phone]

Carol Hunt Jonny Walker
Phone: [phone] Phone: [phone]

Jack Foster
Phone: [phone] 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

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 11/19/2004