seedavework@hotmail.com
|
| Posted: 02/04/2003, 1:11 AM |
|
I read this question and then answered by the author with a reference to an SQL query. I am trying to display firstname and lastname (2 seperate fields) as the Text Column of my List Box. Using Both Table/View and SQL query I can get the data set I need. I cannot figure out how to get CC to display both fields in the listbox. I have tried combinations of + ; , etc. in the Text Column control with no luck. I am hoping somone who has allready figured this out could point me to a simple soultion.
|
|
|
 |
RonB
|
| Posted: 02/04/2003, 1:27 AM |
|
you didn't state the db you are using. But the function you'll have to use is a concat function. in mysql the query qould look something like:
select some_id, concat_ws(' ', firstname, lastname)name from sometable
the result would look like:
1 Jim Jones
2 Jack Smith
don't forget to give the concat an alias because CC needs it to acces it in the listbox construct (boundcollumn some_id, textcolumn the alias( in my example that would be "name")
Ron
|
|
|
|
seedavework@hotmail
|
| Posted: 02/04/2003, 8:53 PM |
|
Thanks for the soultion. I was use it without any trouble.
|
|
|
|
|
