delacosta456
Posts: 5
|
| Posted: 01/13/2011, 4:47 AM |
|
hi
i need to concatenate multiple rows result of an editable grid into a simple label.
more clearly i want my editable grid as below
row1
row2
row3....
...
row n
to be displayed in a in a label = row1, row2,row3.....rown
|
 |
 |
tallmik
Posts: 23
|
| Posted: 01/13/2011, 7:46 AM |
|
If you are using MySQL, a convenient approach might be to use the "GroupConcat" function in your sql.
Group concat will append instances of the column(s) that you are grouping by.
For example, if you have a table of "date" and "temperature", you could select, grouping by month, and have all the temperatures for the month listed in a comma delimited single field.
You can do some quite sophisticated things with this function... good docs at the MySql site.
Regards
Michael
|
|
|
|
delacosta456
Posts: 5
|
| Posted: 01/17/2011, 4:51 AM |
|
thanks for your reply talmik.
in CCS in the before show event off label i dont know how to write it to get it work
|
|
|
|
delacosta456
Posts: 5
|
| Posted: 01/17/2011, 7:15 AM |
|
 Thanks a lot tallmik it worked
|
|
|
|
|
