NS
|
| Posted: 10/02/2002, 2:10 PM |
|
I am using Listbox control on one of the form. Is there any way to display three columns' content instead of one in that Listbox control?
Example: Prefer to display First Name, Middle Name and Last Name columns from the same table.
Using PHP, MySQL.
Thank you.
NS
|
|
|
 |
george l.
|
| Posted: 10/02/2002, 3:58 PM |
|
You should create a listbox and use custom SQL to create a concatonated SQL statement.
Example:
I have this concatonated SQL Statement in my SQL section of my listbox
SELECT vprod_id, vproduct||' - '||'Version'||' '||vprodversion||' / '||'Is Included = '||is_included as concatprodver from vendorproducts
where vprod_id not in
(select vprod_id from relvendassign where rel_id = {rid})
My rows can show up like this:
Orbix - Version 2.3 / Is Included = Yes
Of course this is done with Oracle. I don't know if MySQL supports concatonation operators.
Hope this helps!
g.
|
|
|
|
|
