crimage
Posts: 5
|
| Posted: 02/23/2005, 9:13 AM |
|
I want to use two fields from my table to show up as text column,
i want to us name1 and name2 as one piece, but how do i do that?
anyone who can help me?
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 02/23/2005, 11:42 AM |
|
Assuming that you are using Mysql what you can do is concat the two fields into one field in your select statement. Here is a example:
select nameID, concat(FirstName,' ',LastName) as Name from person
Hopefully this will be helpful to you.
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 02/23/2005, 11:45 AM |
|
Here is an example of the out put of the above select statement
nameid Name
2 Theodore Thunder
3 Van Vanderguard
etc...
|
|
|
|
klwillis
Posts: 428
|
| Posted: 02/23/2005, 11:46 AM |
|
"concat(FirstName,' ',LastName)" is considered a
Database Expression within CCS.
For your field Control Source Type use - Database Expression
For your field Control Source use - concat(FirstName,' ',LastName)
Quote crimage:
I want to use two fields from my table to show up as text column,
i want to us name1 and name2 as one piece, but how do i do that?
anyone who can help me?
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
|
|
|
peterr
Posts: 5971
|
| Posted: 02/23/2005, 11:55 AM |
|
I'd like to add that this question was answered 5-10 times on the forums. You should be able to find couple solutions.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
