DataDoIt
|
| Posted: 02/25/2004, 5:49 PM |
|
CCS2; PHP4; MySQL
How can I display a multi-column listbox?
Data Source Type = Table/View
BoundColumn = EmpID
Text Column = [EmpID | EmployeeName | EmployeeCity] <-- I'd like something
like this.
Thanks.
-Mike
|
|
|
 |
bguthrie
Posts: 31
|
| Posted: 02/26/2004, 7:37 AM |
|
Mike,
I accomplished this by:
Data Source Type = SQL (In your SQL use CONCAT to combine your columns and assign an alias name).
BoundColumn = EmpID
Text Column = "alias name" specified in your SQL statement - this should show up in the drop down listbox.
_________________
Regards,
Bruce |
 |
|
EMG
Posts: 35
|
| Posted: 02/26/2004, 8:37 AM |
|
The only way to make the columns justified is by using a fixed-width font like lucinda console or courier new.
Next you need to determine a length for each column and pad/trim the value. Set the dropdown to listofvalues, do your query in custom code, handle each column, and add to the list of values.
|
|
|
|
DataDoIt
|
| Posted: 02/26/2004, 7:55 PM |
|
CONCAT worked great. Thank you!
-Mike
"bguthrie" <bguthrie@forum.codecharge> wrote in message
news:5403e12a934dd4@news.codecharge.com...
> Mike,
>
> I accomplished this by:
>
> Data Source Type = SQL (In your SQL use CONCAT to combine your columns and
assign an alias name).
> BoundColumn = EmpID
> Text Column = "alias name" specified in your SQL statement - this should
show up in the drop down listbox.
> _________________
> Regards,
>
> Bruce
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
jayme
|
| Posted: 06/16/2004, 7:48 AM |
|
Select CONCAT(field1, field2, field3) FROM table2 AS field1
Give me an error not understanding what CONCAT does. Did I do this incorrectly?
|
|
|
|
david
|
| Posted: 01/19/2005, 3:17 PM |
|
SELECT concat(field1, field2) as "listbox"
FROM
table2
|
|
|
|
|
