montymoose
Posts: 85
|
| Posted: 12/17/2004, 2:34 AM |
|
Hello,
There is probably an easy answer to this, but if there is I can't find it.
I have a dropdown menu on which people choose people out of an adress book - I want the dropdown menu to display a user's first name and last name, but I can only select the firstname field on the Text Column property....
I thought perhaps FirstName+LastName would work but it doesn't I've looked for an answer and can't find one - any help woudl be most welcome
Cheers
Moose : 
|
 |
 |
fsibaja
Posts: 10
|
| Posted: 12/17/2004, 6:36 AM |
|
Well, I don't know which database are you using. I'm using ORACLE.
In the listbox's DataSourceType property choose "Database Expression", and in the datasource type (FirstName||' '||LastName). (In Oracle the (||) is the concatenation operator, so just replace it with your database engine operator).
If you had built in database functions you could also use them here, for example the usefull "Decode" function.
Regards...
_________________
Fernando Sibaja |
|
|
|
peterr
Posts: 5971
|
| Posted: 12/17/2004, 4:42 PM |
|
Please refer to:
http://forums.codecharge.com/posts.php?post_id=11971
http://forums.codecharge.com/posts.php?post_id=34530
http://forums.codecharge.com/posts.php?post_id=15499
http://forums.codecharge.com/posts.php?post_id=20115
http://forums.codecharge.com/posts.php?post_id=23491
http://forums.codecharge.com/posts.php?post_id=43609
http://forums.codecharge.com/posts.php?post_id=44114
http://forums.codecharge.com/posts.php?post_id=44390
http://forums.codecharge.com/posts.php?post_id=44857
http://forums.codecharge.com/posts.php?post_id=49936
http://forums.codecharge.com/posts.php?post_id=50447
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
