displaying data in columns

[Jennifer Smith]

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?

[Mark Schupp]

Re: displaying data in columns

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

https://www.ielearning.com

"Jennifer Smith" <jennifer@nospa m.com> wrote in message
news:414B11BF.F 6829473@nospam. com...[color=blue]
> 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?
>[/color]

[Bob Barrows [MVP]]

Re: displaying data in columns

Jennifer Smith wrote:[color=blue]
> 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?[/color]

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.

[Jennifer Smith]

Re: displaying data in columns

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:
[color=blue]
> Jennifer Smith wrote:[color=green]
> > 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?[/color]
>
> 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.[/color]

[Bob Barrows [MVP]]

Re: displaying data in columns

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:[color=blue]
> 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:
>[color=green]
>> Jennifer Smith wrote:[color=darkred]
>>> 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?[/color]
>>
>> 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.[/color][/color]

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

[Jennifer Smith]

Re: displaying data in columns

Sorry I wasn't more clear. It is 4 rows each containing a letter. So 4
records returned.


"Bob Barrows [MVP]" wrote:
[color=blue]
> 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:[color=green]
> > 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:
> >[color=darkred]
> >> 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.[/color][/color]
>
> --
> 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.[/color]

[Bob Barrows [MVP]]

Re: displaying data in columns

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:[color=blue]
> Sorry I wasn't more clear. It is 4 rows each containing a letter.
> So 4 records returned.
>
>
> "Bob Barrows [MVP]" wrote:
>[color=green]
>> 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:[color=darkred]
>>> 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.[/color]
>>
>> --
>> 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.[/color][/color]

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