G
gold.herman
Hi i am using classical asp and have a problem that I hope someone can
provide an elegant suggestion.
I have a recordset return rows looking like
Name,Stage,Amt
joe,s1,20
joe,s3,30
sam,s2,10
sam,s3,20
sam,s4,30
and I like to constuct an html table looking like:
name s1 s2 s3 s4 s5
joe 20 0 30 0 0
sam 0 10 20 30 0
The stage is fixed s1 to s5 but not all names have all stages. Any
hints how I can convert a recordset to this kind of table?
provide an elegant suggestion.
I have a recordset return rows looking like
Name,Stage,Amt
joe,s1,20
joe,s3,30
sam,s2,10
sam,s3,20
sam,s4,30
and I like to constuct an html table looking like:
name s1 s2 s3 s4 s5
joe 20 0 30 0 0
sam 0 10 20 30 0
The stage is fixed s1 to s5 but not all names have all stages. Any
hints how I can convert a recordset to this kind of table?