2. ASPRunnerPro General questions
  3. On Menu Page show Record Count
This topic is locked

On Menu Page show Record Count

 		6/30/2007 6:18:33 PM
ASPRunnerPro General questions
K
 KingDean author

On the menu page is there a way to show the count of records that exist in a table that would belong to the currently signed on users.
Something like
Messages (25 New)

Tickets (0 New)
Any ideas?
Sergey Kornilov admin 7/1/2007

You need to modify generated menu.asp page for this purpose.

For each table run a query to calculate the number of records and display it next to the table name.
K
 		KingDean author 7/3/2007

You need to modify generated menu.asp page for this purpose.

For each table run a query to calculate the number of records and display it next to the table name.


I would love that, just don't know how.
I have views that all point to one table, work_orders. These views are shown on the users menus according to security. I want the admins to sign on, and with out having to enter the tables they can see from the menu the number of records needing there attention. So, for my one table (work_orders) and the seven views controlled by security, how do it show only the users records that pertain to that view?
Sergey Kornilov admin 7/3/2007

If you are a registered ASPRunnerPro user contact me at support@xlinesoft.com