elaine
|
| Posted: 06/25/2003, 10:14 AM |
|
I have a grid object where one of the fields is an ID from a table in ANOTHER database than the one selected for the grid object. I want to display the value and not the ID. How can I do this? CCS only allows me to select one DB connection per object.
Thanks,
Elaine
|
|
|
 |
RonB
|
| Posted: 06/25/2003, 3:58 PM |
|
You have to get the information from the other db through a before show event or before show row event.
Just set up the connection:
$db=new clsDBconnection2()
$somegrid->somefield->setvalue(CCGetDBValue("select something from some_table where some field =" .$somegrid->somefield->Value,$db));
That's all
Ron
|
|
|
|
|
