Two DB fields in Listbox pull down

CodeCharge Studio

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

Two DB fields in Listbox pull down

Author

Message

xbill99

Posted: 04/22/2005, 10:57 AM

What is the best way to pre-populate a list box with
two database fields?

I have the user first name and last name as seperate columns- but I want to show them both together as options for the standard list box control.

thanks,
-bill

xbill99

Posted: 04/22/2005, 11:17 AM

Found one solution using custom SQL, CONCAT, and SQL alias.

Go to the standard listbox control- change the settings to SQL.

Edit the SQL for the list box and change the SQL to something like:

SELECT CONCAT(last_name,', ',first_name) AS full_name
FROM mytable ORDER BY full_name;

then use the full_name alias in the control.

are there any other ways to do this?

thanks,
-bill

peterr

Posts: 5971

Posted: 04/22/2005, 11:47 AM

This looks like most popular topic on the forums

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home | Search | Members | Register | Login