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.
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.
I 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 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 Replies View RelatedI 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.
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.
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.
I am to build a site onto an ASP server. Anyone here used Dreamweaver and is it just a simple matter of opening up a new ASP page in Dreamweaver and build the site like you would normally do with a HTML page and it will handle the ASP coding accordingly and you can just simply upload it onto an ASP server and it will work?
The site I am to build is basically just a standard html website, but my friend wants me to build it for an ASP server so he has asked me to make sure it is an asp site so I am presuming with the extension .asp
If I build it as a html site to begin with, will converting it to asp be hard. Could I just export my pages into asp or is there more to it?
Can a Html website be loaded and working on an asp server or host?
Is it possible to have a site mixed both html and asp, eg. the home page is html and when you click on shopping cart on the home page it goes to a hopping cart page thats .asp or do they all have to have the same extension.
I have to pass form data from my site to another organizations site using POST method... how exactly do I do that? Im familiar with how to do it within a single site/domain, and cant use querystring... I dont know where to begin.
View Replies View RelatedWhenever I do a site that is mostly static but with some semi-dynamic
sections, I've struggled to find a good site search solution without
paying for a hosted search service.
I like the FSO-based search engines, but they fail to pick up on some of
the dynamic part.
I was just creating a Google sitemap and it made me wonder: has anyone
created or seen a script that uses the XML Google sitemap to power a
search engine for your own site?
Seems like if you were keeping it updated for Google, why not use it for
your own site?
How can my members log out of my shopping website? I can't seem to figure it out. I'm using a session cart where users can log in before shopping or log in upon checking out products. How do they log out??? I'm using ASP and oracle sql.
View Replies View RelatedI would like to create a site map for my map site which is in ASP. I tried
to use Visio to create a web site map but it fails because my asp home page
requires to authenticate. Is there any other tool to create a sitemap from
username/password protected website?
I want to open a website let say
google.com in my own site.but i want to replace some of its images with my own.
but remember site ( google.com ) will be running in my website everything should be of google but look will be mine.i wanted to do it for my own two websites i just used name of google.com to demonstrate my problem
some code to look through for getting started, i still need to sort out thing like a file to hold all the db stuff so i can call the functions rather than type it every time. cleaning up really .
View Replies View Relatedi have a slight background in HTML and basic web dev. I have been asked to create basically the following, it will be my project over the next couple of months. I basically want to build an e-commerce website that will take all data from a database. It all needs to be dynamic, products added to the database would automatically update in the website, the navigation also needs to be dynamic, it needs to be low maintainence, i aim to have the checkout to save customers details to a seperate database, the payment process would have completed, no payment details would be saved.
What do you think on the above. Does any one have firstly any code they may be able to give me, to help me along the way. it does need to be done on a budget, I will buy code if need be. What is the best program to develop such a website in?
I'm looking to eliminate all lag on my site and I have a couple questions regarding databases. Is it possible to open 2 ADODB connections at once? I want to put my sites boards on a different database than everything else but I want to get user information to update in the main db. How would I go about doing this?
Does closing all the stuff you opened in your ADODB connection make a difference? Does it resuly in the use of more bandwidth and site lag?
i have been asked to create a 'site map' for an ASP / Access DB website which i have just started. Can someone explain to me exactly what a 'site map' is and what it is useful for please?
View Replies View Relatedi've got a local server on another pc (ip address:192.168.1.243) but when I want to connect to ASP site that's on that computer it can't. when type "http://192.168.1.243" in my browser it returns this:
IE says: "impossible to find the page" and Firefox says: "the operation timed out when attempting to contact 192.168.1.243". I know that ASP works, because when we try it on the localhost it works (but that's not my computer so I can't use it).
How create site with webmatrix with MySql ?
View Replies View Relatedi have a simple asp counter in my site, the counter uses a access db & cookies (so every visitor will be counted once).
in the past days the counter has gone wild & count goes from 300 in ordinary days to 1000.
i guess this is because of robots, crawls, worms etc. is there any way i can count only real visitors?
I have a situation where I have a customer with one e-comm site and two domain names. Both domains currently point to the one site but they want different logos and purchase tracking for each domain name as visitors come through. I am not that well versed in using the HTML headers but somewhere I seem to recall a way of using the headers to identify the url/domain and then redirect or setup session variables for handling the rest.
If this is ringing a bell with anyone I could use a pointer to more info on this.
anyone knows a VBScript that acts as a webbrowser? I am
behind a firewall and my local machine is not visible to the internet,
but I have a access to some webspace with asp VBScript. With the right
script I could tunnel pages and sites from my local machine
We have a requirement to build a site to work on a mobile phone. Its a property search system and the site needs to show properties from the database based on the users location using the gprs position.
Can anyone point me in the right direction for doing this?
I just need a simple ASP tutorial site for beginners.
View Replies View RelatedI like to create a search mechanism in my web site. This
search engine will look for the keyword in my web
directory and return the file location as hyperlink. Now,
I have included all the conent of my web site as include
text file. Example: I have index.asp and content of
index.asp located at include/index.txt. If search query
locates at index.txt I want my search code to return
index.asp instead of index.txt as search result. How can I
do it.
Currently I have someone wanting to transfer their site, ran in IIS/ASP, to one of my servers so that I can host if for them. I am running Windows 2003 Server with IIS 6. I have a disk that has the files for the site (from root down) I created a new site, put the files in there and configured the properties in IIS, but I only get a 500 (Internal Server Error) error page when it tries to run. I set the home directory, permissions, documents to point to the index.asp file, etc...
View Replies View RelatedI have got a small problem as follows, i am trying to test my web page on the live site of which it doesn't load to the database. hence it loads on the production server.
View Replies View RelatedI have a Log In form that has the user enter a username and password. Then in the log in process the needed user fields that control the access the user has on the site are stored in different session variables. Basically, the site is dependent on the session not getting timed out.
With this in mind is it better design to set the session timeout value to a value greater then 20 minutes or would it be better to have a script check to make sure the session is active before any actions are taken? I guess it is possible that I should do both.
Then, when checking if the session is active, is there a special script for this or do I just have a variable called SessionActive in session and set this to true and then check it anytime before I initiate a process so if it is any value but true, then I display a page saying the session has expired and have them log in again.
Then, on the site I have a bottom menu that allows the user to navigate to about any page in the site from any page in the site. So basically it is possible that the user could log in to the database and then click a link to go to a static page.
Then they could hit the browsers back button to take them back to the dynamic ASP page. Is there any concerns with session variables in this case? Also, once a user logs into a database, should they be able navigate to other static pages without first logging out?
The reason I put this post in the ASP section is because the dynamic code is written in ASP.
I am looking to create a script in asp that will gather the page title of each page in my database and display as the anchor text of the url. This is basically so that I can have a site map with all pages in database. I also want to limit the amount of links to say 80 per page.Has anyone done this before and if so could you let me know where to go to find out more info on this or how to go about it
View Replies View Related