mbendit
Posts: 7
|
| Posted: 10/04/2006, 7:58 PM |
|
Is there any way to build a directory from a category table that has multiple root records? I need to create multiple directories and prefer to use just one database table. If I have more than one root record, how do I tell the directory builder which root record to use for "Main"?
Thanks.
Michael
_________________
Michael Bendit
Parallon Consulting
New York, NY
888.447.1591 |
 |
 |
peterr
Posts: 5971
|
| Posted: 10/04/2006, 10:32 PM |
|
The main approach I can think of would be to create the directory like usually, then later add a WHERE parameter in the Data Source so that it displays only those records that match specific root records.
Not sure if anyone has done this previously, so it could involve some further testing on your part.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
mbendit
Posts: 7
|
| Posted: 10/05/2006, 3:50 AM |
|
Peter,
Thank you for the quick response. I will try that approach.
I think I need to create a new Directory page anyway for each different directory (from the same table). Is there also a way to set a different Root Category Identifier for each different directory once the page has been built? I can't find the "Root Category Identifier" property anywhere. And can this Root Category Identifier be other than "0" or "-1"?
Best,
_________________
Michael Bendit
Parallon Consulting
New York, NY
888.447.1591 |
|
|
|
peterr
Posts: 5971
|
| Posted: 10/05/2006, 12:01 PM |
|
You'd do this in the Data Source property as mentioned above. You can do whatever you need, regardless how you call it or what it is. You can just narrow the results the way you want.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
peterr
Posts: 5971
|
| Posted: 10/05/2006, 12:07 PM |
|
I just looked at the Directory example in CCS Example Pack 2 and I see this in the Data Source:
WHERE cat.category_id_parent = category_id
So you would just need to add additional conditions for the records you want to display.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
mbendit
Posts: 7
|
| Posted: 10/18/2006, 7:52 AM |
|
Peter,
Thanks so much for your help. I did it by adding a field to the categories table to segment the categories into different industries. I use the WHERE clause to show only those directory entries of interest. Works like a charm.
_________________
Michael Bendit
Parallon Consulting
New York, NY
888.447.1591 |
|
|
|
