I have SQL database and ASP web pages. I want to make some statistics for tables in the database, and if possible I want also some charts such as MS Excel. Is there an easy way to do so in ASP (using Macromedia Dreamweaver) ?
View RepliesI need to work on a project with a state map with associated counties. On
clicking a county, it should give the summary stats of crime for that county
on a box on the page. On double clicking a county a new page with detail
crime summary for that county should pop up.
I am trying to do basic statistics for a site. all I want is a list of unique hits (per page) by date. I would prefer to do the statistic software in asp but I don't want to have to change all the pages to .asp so I want something that could be hit using a hidden image or javascript. Does anyone have similar code they have done?
View Replies View RelatedI want to keep control of the statistics about my website, but I don 't want to loose previous hits (if I 'm not mistaking they are kept in the log-files?). I want to know how many visitors are online.
how many visitors my website (a specific page) has had today, this month and the total amount of visitors. This cannot appear however on the page itself, but on a password-protected page.
I have a table in my (Access) database called stats with the following columns,
Quote:
-- statidautoincrement PRIMARY
-- ipaddresstext
-- useridnumber
-- allrawmemo
-- languagetext
-- pagetext
-- datetimelinenumber
-- useragentmemo
-- cookiememo
-- sessionidnumber
-- countrytext
-- loadtimenumber
Can you think of a few possible ideas of displaying the data, and giving the SQL query(s) for it? Something like, SELECT AVG(loadtime) AS averageload FROM stats.
Can ASP answer these questions for me?
1. Who is visiting my website?
2. Which pages are they visiting?
3. Which site is the most frequently visited?
4. What location are they from?
and other questions similar to the above.
I know very little about log files, but I really want some accurate way to track users on my site: referrals,hits/sessions, browser types, etc. I think the best way to do that is via the log files which I can see on the webserver but I don't know the best way to access and analyse them.
I have build a content management system based on Access/ASP and I'd like to try and incorporate site stats.
In database exist survey results. Specific results from multiple choice - multiple answer survey (checkbox) are in tbl_results table (example excerpt):
IDresult__IDquestion_answers
....
24________72_________178,180,191
25________77_________221,224
26________79_________291,298,301,302
27________84_________522,523,525
....
table answers has ID numbers of answered answers, delimited. Anybody has solution to use those ID numbers as foreign key against table tbl_answers, in order to make possibility to make query for better statistics .
I would like to provide all my members 35 000 ordinary consumers with high energy bills) with a system for keeping track of their use of energy and water by reporting meter readings every month. The readings are compensated for day of reading and also the local temperature during the month ("degree-days")
In step one I am only looking for management of meter readings & graphic representation per month of consumption. No consideration of prices and tariffs are needed.
I would like to do is to generate statistics from my access db.
Within the db there are fields for each of the 11 plaers in the team each week, i.e. p1, p2, p3 ...... in each one will be a name, i.e Bill Bloggs but the name could appear in any one of the 11 fields.
What I would like to do is count the number of occurances of bill bloggs in the 11 fields and return it on my site as a table, i.e.;
name - times played
bill bloggs - 6
I have on my website tutorials. There are 6 tutorials. I have a table in my databse for registered users. I wish to know the statistics for these users. That is the time each user has spend on each of these tutorials. eg. a statistics like
Authorized user1:
Tutorial1: 30 min.
Tutorial 2: 15 min.
.
.
Like this. I have allotted about 100 hours for each user, so I need to maintain this statistics so that I come to know that how many hours have been used and how many hours are still left. Can somebody guide me how to go about it.