Steve
|
Posted: 03/31/2004, 7:27 AM |
|
I have a check box list working just fine but I am trying to add an additional "Text Column" possibly two with fields pulled from the Database. I did se where this is defined in Classes.php, but was hoping that it was possible perhaps in a "Before Show" event.
So it would be something like:
[ ] {Description}
{Type} - {Subject}
[ ] {Description}
{Type} - {Subject}
etc...........
|
|
|
RonB
Posts: 228
|
Posted: 03/31/2004, 8:40 AM |
|
Use sql to concatenate the fields you want:
select field1, concat_ws('-',field2,field3) as textcolumn from table
In the properties box you should now be able to select field1 as the bound column and the field textcolumn as text.
Above is the concatenate syntax fro MySQL
|
|
|
|