I have an ASP script that selects data from a database, treats the data and produces a report.Now i need to run that report daily, and i would like to automate the run - every day at n o´clock. What is the best way to do it?
View RepliesI used ASP and wrote a login / logout program. This is to capture people who comes into my lab from 0800 to 1700.
The data collected are stored in a table
Userid Date_in Time_in Date_out Time_out
123 4/3/2005 0900 4/3/2005 1000
121 4/3/2005 0925 4/3/2005 1100
122 4/3/2005 1200 4/3/2005 1400
127 4/3/2005 1500 4/3/2005 1600
125 4/3/2005 1503 4/3/2005 1630
122 5/3/2005 0800 5/3/2005 0845
The manual way of calculating utilization on 4/3/2005 will be [(Time between 0900 to 1100) + (Time between 1200 to 1400) + (Time between 1500 to 1630)] / (Time between 0800 to 1700) X 100%
The problem is that depending on what time the next person arrives, there might be an overlap in time. For example, A comes at 9am and leaves at 11am. B comes at 9.30am and leaves at 12pm. The total duration will be from 9.00am to 12 pm that is 3 hours instead of (rs("time_out")-rs("time_in")) = (11-9) + (12-9.5) = 4.5 hours
Is there a formula or way to automate this process?
Does anyone know how to autome word mailmerge to create Letter forms using ASP?
View Replies View RelatedEveryday of my life the last year has started by searching through a lot websites in order to find the latest news, and then making a link to that news from my webpage. What I have always dreamt about is some kind of automation.
Is it possible to make a script in ASP that searches through a website and gathers info on title, URL and such, and then automatically inserting it into my website (via for instance a SQL database)?
if it is possible to have a web page that can be created into a pdf via a click of a button, similar to the save as pdf option. Is this possible?
View Replies View RelatedI want to have an automated recordID with the following format:
<last 2 digits of the current year>+<last 2 digits of the current month>+<number series 001-999>
example: 0409001
(where 04 stands for 2004, 09 for the month of september, then 001 refers to the 1st record)
then when month changed to october the number will be reset to 001 so the recordID now must be 0410001
having that format i can't use the database itself by setting the recordID as autonumber only..
I'm building an asp website with calendar for a High School Basketball team. A database holds dates for all events on the calendar. I want to build a schedule for a SEASON automatically based on the current date() they are visiting the site, and a SEASON is June of one year through May of the next. Example:
If they are accessing the schedule in January 2007, a query will filter all events for the 2006-2007 season (June of 06 through May of 07)
If they are accessing the schedule in August of 2007 I want them to get events filtered from June of 2007 through May of 2008 (the 2007 - 2008 season).
I can't seem to get my mind around the logic (and code) needed to build this query. If i build a query based on the year alone, by picking 2007 you would get the end of the 2006-2007 season and the beginning of the 2007-08 season (events from Jan 2007 through Dec 2007).
I have the ff. data:
Customer Name
Date
Subject
Problem
then when the user submitted the form, the ticket number will be automatically generated with the following format:
<last 2 digits of the current year>+<last 2 digits of the current month>+<number series 001-999>
example: 0409001
(where 04 stands for 2004, 09 for the month of september, then 001 refers to the 1st record)
then all the data will be saved to the database.
my problem is how can i do this?
I am generating rtfs. Is there anyway to automate the printing of the rtfs after they have been created?