Databound Checkboxlist question

[tjonsek]

Is it possible to concat to fields from a dataset together to create
the checkboxlist labels?

I'd like to create a form with a checkboxlist with the text of the
label for each item coming from a combination of date,description and
location fields in a database

 

[Guest]

Simply create your select query that pulls the data out of the database like
the example below

Select DateField + " " + DescriptionField + " " + LocationField AS
ConcatField.

The Concat field will then contain the other fields seperated by a space.

 

[tjonsek]

cool. thanks!