Markie
Posts: 251
|
| Posted: 01/11/2009, 2:33 AM |
|
I have a grid named photodbase
this grid has records from a mysql table
in this grid i have a label in which i want to show information from a different table. Both tables have a corresponding field with the name album.
My label has a dlookup action:
expression: description
domain: albums
criteria: "album=".$photodbase->album->GetValue()
connection: connection1
convert result to: text
type of target: control
target: description
In the grid the hidden field album exists, showing the name of the album
However, there are no browser errors but the description label is empty
What do I do wrong ?
_________________
The Netherlands, GMT+1
Tools: CCS 5.1, Windows 7, Navicat, Ultraedit
Local server: XAMPP with Apache, php and MySQL
Webserver: Windows 2008 IIS 7, php and MySQL |
 |
 |
Gena
Posts: 591
|
| Posted: 01/11/2009, 2:41 AM |
|
try to move this code into Before Show Row event
_________________
Gena |
|
|
|
Markie
Posts: 251
|
| Posted: 01/11/2009, 2:55 AM |
|
Hi Gena, unfortunately this makes no difference. Still no text in my label ...
Do you think my criteria is good ?
_________________
The Netherlands, GMT+1
Tools: CCS 5.1, Windows 7, Navicat, Ultraedit
Local server: XAMPP with Apache, php and MySQL
Webserver: Windows 2008 IIS 7, php and MySQL |
|
|
|
Gena
Posts: 591
|
| Posted: 01/11/2009, 3:17 AM |
|
try to put some echo before to check if you get good value
echo $photodbase->album->GetValue();
or ever why don't you use VQB and make some JOIN with your related table? then just show field you need.
_________________
Gena |
|
|
|
Markie
Posts: 251
|
| Posted: 01/11/2009, 3:37 AM |
|
"or ever why don't you use VQB and make some JOIN with your related table? then just show field you need."
Yes, this does the trick !
Thanks again Gena
_________________
The Netherlands, GMT+1
Tools: CCS 5.1, Windows 7, Navicat, Ultraedit
Local server: XAMPP with Apache, php and MySQL
Webserver: Windows 2008 IIS 7, php and MySQL |
|
|
|
|
