kernel
|
| Posted: 05/27/2003, 7:04 PM |
|
When I use a Grid Form to list all records of a table.
data of table
(column:col1 & col2)
----------
col1,col2
----------
1,2
1,3
1,4
2,6
2,8
I want to show as
col1,col2
---------
1,2;3;4
2,6;8
I have used checkbox list ,but it show as
1,2;3;4;6;8
2,2;3;4;6;8
Somebody can help me...thx
|
|
|
 |
Edd
|
| Posted: 05/29/2003, 4:19 AM |
|
There is no easy answer.
You can perform "pivot table" functions using some databases, eg MicroSoft's CUBE statement in SQL, BUT your REAL problem is that you don't know how many columns per row you could possible get.
If it is limited you could try a SQL temporary table solution.
My advice is to rethink the problem - in the context ot a fixed web page or in pure ASP or PHP create the grid by hand (outside of codecharge).
Sorry not much help :=(
Edd
|
|
|
|
|
