cornettt
|
| Posted: 10/29/2002, 10:03 AM |
|
How would list categories and display how many records are in that category. Similar to the Script Archives and download sites.
Example:
ASP (16)
Java (29)
Visual Basic (12)
I am using CSS, ASP w/Templates, VBScript.
Thanks.
|
|
|
 |
Nicole
|
| Posted: 10/30/2002, 7:16 AM |
|
Hello,
Create form Before Show Row event and calculate the number of items in each category. E.g.:
form_name.field_name.Value = CCDLookUp("table_name", "count(*)", "category_id=" & form_name.category_id.Value, DBconnection_name)
Note that category_id field should exist on the form. Do not forget to replace "form_name", "field_name", "connection_name", etc. with real names.
|
|
|
|
imranz
|
| Posted: 10/30/2002, 10:22 AM |
|
There are two types of record counting examples in the Counting Sheep article. The second part of the article handles your type of question.
http://www.gotocode.com/art.asp?art_id=230&
|
|
|
|
|
