ComputerForce
|
| Posted: 12/01/2002, 12:37 AM |
|
Can Codecharge Studio handle Listbox with second column (we know first column is invisible and control) made from two or more fields from database (like in MS Access)?
Example:
First table is Work table
ID_Work
.....
.....
ID_Empl
Time_Start
Time_End
Success
.....
.....
second is Employee table with:
ID_Empl,
Empl_Name,
Empl_Lastname
Is it possible to make listbox with something like this:
visible column to choose from is complete next row:
Empl_Name+", "+Empl_Lastname
and, maybe with this order:
ORDER BY Empl_Lastname, Empl_Name.
Is this possible in CCS 1.07??
Is this possible in CCS 2 BETA??
|
|
|
 |
Cazzani
|
| Posted: 12/01/2002, 9:32 AM |
|
As far as we know you can't do it in CCS 1.07 (don't know in beta 2 yet) but is is very easy to accomplish the same thing creating a Query in Access and then using that query as a List Data Source of your listbox in CCS.
For instance, you create an Access Query like this:
Q_FOR_MY_LISTBOX with the following fields:
ID_Empl,
Empl_Name,
Empl_Lastname
MyDisplay: [Empl_Name] & "," & [Empl_Lastname]
Then in the CCS ListBox you select Q_FOR_MY_LISTBOX as a ListDataSource, ID_Empl as Bound Column and MyDisplay as Text Column
I hope this helps
Stefano,
Milan, Italy
|
|
|
|
ComputerForce
|
| Posted: 12/03/2002, 11:54 AM |
|
Thanks!
I did use Perl connections to MS Access databases (ODBC) thru Dave Roth's module, and I did make few databases PHP/MyODBC connections. It works, but, at the moment I am trying to convert everything to MySQL. It is not so easy but there must be a good solution. Thanks again! Does anybody have similar solution (query made field in one column) for MySQL?
|
|
|
|
|
