Ask a Question related to ASP, Design and Development.
-
Mike #1
96 rows of data into a table
I have a select that will return 96 rows of data.
Data looks like:
A1
A2
...
A12
B1
...
B12
....
....
H12
I need to put this in a table like
A1 A2 A3 .... A12
B1
.................................
..................................
H1 H2 H3 .... H12
Getrows doesn't work since it thinks these are 96 rows instead of 96 pieces
of data in 8 rows
My brain doesn't seem to be clicking this morning. Anything simple I am
missing?
Mike
Mike Guest
-
#25473 [Opn->Bgs]: Updating single row in table causing all rows in table to be updated.
ID: 25473 Updated by: sniper@php.net Reported By: jim at bluedojo dot com -Status: Open +Status: ... -
#25473 [Fbk->Opn]: Updating single row in table causing all rows in table to be updated.
ID: 25473 User updated by: jim at bluedojo dot com Reported By: jim at bluedojo dot com -Status: Feedback +Status: ... -
#25473 [Opn->Fbk]: Updating single row in table causing all rows in table to be updated.
ID: 25473 Updated by: sniper@php.net Reported By: jim at bluedojo dot com -Status: Open +Status: ... -
#25473 [Opn]: Updating single row in table causing all rows in table to be updated.
ID: 25473 User updated by: jim at bluedojo dot com Reported By: jim at bluedojo dot com Status: Open Bug Type: ... -
#25473 [NEW]: Updating single row in table causing all rows in table to be updated.
From: jim at bluedojo dot com Operating system: WinXP PHP version: 4.3.3 PHP Bug Type: MySQL related Bug description: ... -
Aaron Bertrand - MVP #2 Re: 96 rows of data into a table
If there are always 12 columns, you could adjust this script:
[url]http://www.aspfaq.com/2247[/url]
Or maybe you are looking for a crosstab:
[url]http://www.aspfaq.com/2462[/url]
"Mike" <Mike@nospam.com> wrote in message
news:eJfsdr9lDHA.2312@TK2MSFTNGP12.phx.gbl...pieces> I have a select that will return 96 rows of data.
>
> Data looks like:
>
> A1
> A2
> ..
> A12
> B1
> ..
> B12
> ...
> ...
> H12
>
> I need to put this in a table like
>
> A1 A2 A3 .... A12
> B1
> ................................
> .................................
> H1 H2 H3 .... H12
>
> Getrows doesn't work since it thinks these are 96 rows instead of 96> of data in 8 rows
>
> My brain doesn't seem to be clicking this morning. Anything simple I am
> missing?
>
> Mike
>
>
Aaron Bertrand - MVP Guest
-
Mike #3 Re: 96 rows of data into a table
Thanks Aaron. The first should work.
Mike
"Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
news:OZ3pgu9lDHA.3732@tk2msftngp13.phx.gbl...> If there are always 12 columns, you could adjust this script:
> [url]http://www.aspfaq.com/2247[/url]
>
> Or maybe you are looking for a crosstab:
> [url]http://www.aspfaq.com/2462[/url]
>
>
>
>
> "Mike" <Mike@nospam.com> wrote in message
> news:eJfsdr9lDHA.2312@TK2MSFTNGP12.phx.gbl...> pieces> > I have a select that will return 96 rows of data.
> >
> > Data looks like:
> >
> > A1
> > A2
> > ..
> > A12
> > B1
> > ..
> > B12
> > ...
> > ...
> > H12
> >
> > I need to put this in a table like
> >
> > A1 A2 A3 .... A12
> > B1
> > ................................
> > .................................
> > H1 H2 H3 .... H12
> >
> > Getrows doesn't work since it thinks these are 96 rows instead of 96>> > of data in 8 rows
> >
> > My brain doesn't seem to be clicking this morning. Anything simple I am
> > missing?
> >
> > Mike
> >
> >
>
Mike Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
