Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old June 28th, 2007, 07:38 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: abu dbabi, , United Arab Emirates.
Posts: 518
Thanks: 0
Thanked 0 Times in 0 Posts
Default asp and graph

I use following query in asp.

DECLARE @totalVideos int
SET @totalVideos = (SELECT COUNT(*) FROM Training_Module)
SELECT t2.Name,t3.Department_Name, t4.Position_Name, COUNT(t1.emp_id) as ViewCount,COUNT(t1.emp_id)*100/44 as

ViewPercentage
FROM Module_View t1
JOIN Employee t2 ON t1.emp_id = t2.emp_id
JOIN Department t3 ON t2.Department_Code = t3.Department_Code
JOIN Position t4 ON t2.Position_Code = t4.Position_Code
GROUP BY t1.emp_id,t2.Name,t3.Department_Name, t4.Position_Name

it retreive the percentage safety video records.
like this

name viewcount percentage%
-----------------------------
Peter 10 22
Jones 16 36
Marksr 8 18
......
...

how can display the graph of above query record in asp ?

regards
Mateen


Similar Threads
Thread Thread Starter Forum Replies Last Post
sql query in asp graph mateenmohd Classic ASP Professional 6 August 6th, 2007 01:14 AM
Graph in asp mateenmohd Classic ASP Basics 0 June 2nd, 2006 11:05 AM
Any Expert know using Graph in ASP itHighway Classic ASP Basics 2 March 25th, 2005 05:53 PM
Display a Report and Graph an ASP rekha_jsr Classic ASP Basics 0 December 14th, 2004 03:37 AM
graph pab006 Classic ASP Basics 1 April 30th, 2004 10:08 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.