By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,639 Members | 1,988 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,639 IT Pros & Developers. It's quick & easy.

displaying data in columns

P: n/a
I want to be able to display my recordset as follows:

a e
b f
c g
d h

Instead of :
a b
c d
e f
g h

Any links to some examples?

Jul 19 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Do you need each piece of data in its own cell?

If not

<tr>
<td>
list the first column here using <br> or <p> for line breaks
</td>
<td>
list the second column here using <br> or <p> for line breaks
</td>
</tr>

If you do need separate cells put the data into an array (maybe with
GetRows()) and grab the element you need as you generate the table cells.
--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com
"Jennifer Smith" <je******@nospam.com> wrote in message
news:41***************@nospam.com...
I want to be able to display my recordset as follows:

a e
b f
c g
d h

Instead of :
a b
c d
e f
g h

Any links to some examples?

Jul 19 '05 #2

P: n/a
Jennifer Smith wrote:
I want to be able to display my recordset as follows:

a e
b f
c g
d h

Instead of :
a b
c d
e f
g h

Any links to some examples?


Does this recordset contain two fields? Or does each letter in your example
represent a row in the recordset?

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.
Jul 19 '05 #3

P: n/a
Sorry each letter represents a field.

I need to order my data alphabetically in columns.

For example - I return a recordset of a, b, c, d

I would want to display like this:
col 1 col2
a c
c d

Thanks :)

"Bob Barrows [MVP]" wrote:
Jennifer Smith wrote:
I want to be able to display my recordset as follows:

a e
b f
c g
d h

Instead of :
a b
c d
e f
g h

Any links to some examples?


Does this recordset contain two fields? Or does each letter in your example
represent a row in the recordset?

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.


Jul 19 '05 #4

P: n/a
I'm sorry, I'm still not clear about what your recordset contains. Is it 4
rows, each row containing a letter?

field1
a
b
c
d

Or is it 2 rows, each row containing two fields?

field1 field2
a b
c d

Perhaps if you showed us the SQL statement used to generate the recordset,
all would become clear.

Bob Barrows
Jennifer Smith wrote:
Sorry each letter represents a field.

I need to order my data alphabetically in columns.

For example - I return a recordset of a, b, c, d

I would want to display like this:
col 1 col2
a c
c d

Thanks :)

"Bob Barrows [MVP]" wrote:
Jennifer Smith wrote:
I want to be able to display my recordset as follows:

a e
b f
c g
d h

Instead of :
a b
c d
e f
g h

Any links to some examples?


Does this recordset contain two fields? Or does each letter in your
example represent a row in the recordset?

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.


--
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.
Jul 19 '05 #5

P: n/a
Sorry I wasn't more clear. It is 4 rows each containing a letter. So 4
records returned.
"Bob Barrows [MVP]" wrote:
I'm sorry, I'm still not clear about what your recordset contains. Is it 4
rows, each row containing a letter?

field1
a
b
c
d

Or is it 2 rows, each row containing two fields?

field1 field2
a b
c d

Perhaps if you showed us the SQL statement used to generate the recordset,
all would become clear.

Bob Barrows
Jennifer Smith wrote:
Sorry each letter represents a field.

I need to order my data alphabetically in columns.

For example - I return a recordset of a, b, c, d

I would want to display like this:
col 1 col2
a c
c d

Thanks :)

"Bob Barrows [MVP]" wrote:
Jennifer Smith wrote:
I want to be able to display my recordset as follows:

a e
b f
c g
d h

Instead of :
a b
c d
e f
g h

Any links to some examples?

Does this recordset contain two fields? Or does each letter in your
example represent a row in the recordset?

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.


--
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.


Jul 19 '05 #6

P: n/a
I would do something like what Mark said (this is untested and may need to
be tweaked):

'open the recordset, then
arData = rs.GetRows
rs.close:set rs=nothing
cn.close:set cn = nothing

if isarray(arData) then
'assuming <table> tags are already in place
for i = 0 to ubound(arData,2)
if i mod 2 = 1 then '(if it's an even numbered row)
response.write "<td>" & arData(0,i) & "</td></tr>"
else
response.write "<tr><td>" & arData(0,i) & "</td>"
end if
next
if ubound(arData,2) mod 2 = 0 then
response.write "<td></td></tr>"
end if
else
'handle situation where no data was returned
end if
Jennifer Smith wrote:
Sorry I wasn't more clear. It is 4 rows each containing a letter.
So 4 records returned.
"Bob Barrows [MVP]" wrote:
I'm sorry, I'm still not clear about what your recordset contains.
Is it 4 rows, each row containing a letter?

field1
a
b
c
d

Or is it 2 rows, each row containing two fields?

field1 field2
a b
c d

Perhaps if you showed us the SQL statement used to generate the
recordset, all would become clear.

Bob Barrows
Jennifer Smith wrote:
Sorry each letter represents a field.

I need to order my data alphabetically in columns.

For example - I return a recordset of a, b, c, d

I would want to display like this:
col 1 col2
a c
c d

Thanks :)

"Bob Barrows [MVP]" wrote:

Jennifer Smith wrote:
> I want to be able to display my recordset as follows:
>
> a e
> b f
> c g
> d h
>
> Instead of :
> a b
> c d
> e f
> g h
>
> Any links to some examples?

Does this recordset contain two fields? Or does each letter in your
example represent a row in the recordset?

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.


--
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.


--
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.
Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.