marclinton
Posts: 3
|
| Posted: 07/15/2005, 2:33 AM |
|
I have two tables, named Product and Label resp. A product can have two different labels, so in the CCS Visual Query Builder I have added the Label table twice and created two left joins from the Product table to the two Label tables (PrdLabel --> Label_LabelID and PrdLabel1 --> Label1_LabelID).
In my grid - showing the Product data - I want to display the label names rather than the label ID's as stored in PrdLabel and PrdLabel1. So I have added two additonal labels in my grid and have the data source set to Label.Name and Label1.Name resp. However, I'm not getting any results for either of the fields. I do get the correct label name when I join the Label table just once, e.g. PrdLabel --> LabelID, but the name disappears as soon as I create the second left join, although I have updated the data source.
I have tried different aliasses, too, but without any results.
Can anyone help?
_________________
Marcel Lint
DSM NeoResins |
 |
 |
donb
Posts: 52
|
| Posted: 07/20/2005, 6:50 AM |
|
I'd guess the join is returning zero rows, or the name columns are NULL for some reason. About all you can do is to experiment with the query outside of CCS to find out what data you are actually working with. It's probably not what you think it is and that's why you get the 'blank' labels.
_________________
http://www.gotodon.com/ccbth |
|
|
|
marclinton
Posts: 3
|
| Posted: 07/21/2005, 12:31 AM |
|
donb,
Good suggestion. I copied the SQL from CSS to MS Query Analyser and ran the query. All the data were in the result as I expected.
I also used the review data option in the data source window of CSS and again all data were there as expected.
So the query is OK, but somehow CSS can still not make these data visible in the webpage.
Any more suggestions?
_________________
Marcel Lint
DSM NeoResins |
|
|
|
peterr
Posts: 5971
|
| Posted: 07/21/2005, 1:03 AM |
|
Looks like the Countrol Source property of your label is wrong. Make sure that you select one of the available values after you change the grid's data source. The "Label.Name" that you provided doesn't look right and actually I don't understand where you have entered such value.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
marclinton
Posts: 3
|
| Posted: 07/21/2005, 3:49 AM |
|
peterr,
Even if I have CSS build the grid for me the label name fields still stay empty. As soon as I remove one join and adjust the control source of the label name field, then the label name shows up.
I really don't know what I am doing wrong here.
_________________
Marcel Lint
DSM NeoResins |
|
|
|
|
