On-call Schedule
how to create an on-call schedule. It just needs to be really simple. Basically a two column table with names on the left and dates on the right. There is a specific order that the names are in in the Access db and need to stay in that order to keep the schedule rotating properly.
I want the name of the person who is on-call this week to be at the top of the table and then when the on-call week is over that person drops to the bottom of the table. A typical on-call week is from Mon-Sun. Also making the dates populate correctly without having to manually enter them in the db
View Replies
ADVERTISEMENT
I want to create ASP page that shows the schedule of TV station. Since each day's (Monday - Sunday) schedule is different, and I want each day will display the schedule on that day of a week. I wonder if I need to create 7 different ASP pages and call different one on each day? This is just my idea, but I think this is not a good solution.
View Replies
View Related
I am trying to create a Function to delete records in database on daily basis. I am stuck with date/time.
Sql:
Delete * from MyTable where date = &date& 'not sure of quotes also.
How can I rewrite my sql to delete records daily at 8.00pm?
View Replies
View Related
I want to allow the users to shedule a particular task (shedule the time and date of inserting thier forms and data into the table ) such that i ll provide a simple form where the user can enter his name , age , and some other details at the end of this form , there is field to enter the date and time of inserting those fields into the table in the database,so that data inside this form will be inserted into the table as per the user scheduled date and time
View Replies
View Related
How to do the above without global.asa?
I need the script to run every 24 hours. Currently I am using database.
If rsDB("date") < DateAdd("h",-24, Now()) then
<--SCRIPT HERE-->
Then I have a script that puts the rsDB("date") to Now().
View Replies
View Related
Any way to do a Scheduled task without having access to a "Scheduled Task" feature in the hosting control panel. IOW, I want to run a single Update Table query every Sunday at Midnight but I don't want to have to manually run it. I use SQL 2000 on a Win2k machine.
View Replies
View Related
I'm trying to find a way where I can schedule a task to be run within a web site, either in VB (COM) or within the web site (ASP). What I want to do is to run a daily scheduled task which will cleanup a desired folder within the web site. As I say, this must be an automated scheduler which can kicked off by itself without any interaction from a user etc.
View Replies
View Related
i have this event sign-up program that displays events from access databases and allows a user to click on a sign-up button to sign up for these events. currently when viewing an individual summary, the users see a listing of events they've signed up for, but it's been suggested to create a grid schedule for a better visual.
these events cover a 9 day period (Friday through Saturday) and i was wondering if there's a relatively easy way to create a grid schedule for the users?
View Replies
View Related
We have a web application to allow user register a meeting and want to automatically add into their outlook calendar. how to do this in asp?
View Replies
View Related
I wanted to run an ASP script to send mails, to be executed every 24 Hours.
View Replies
View Related
I have developed a website in ASP 3.0 and Acesss 2000/SQl
Server.
I wan my web site sent invoices to my customer
automatically ...at some specified time
(lets say it execute ceratain ASP page at 3:00 am that
send emails)
how can i schedule that?
Should i write some program (EXE) that will run on web
seerv to do this task or do we have soem other decent
solution?
View Replies
View Related
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).
View Replies
View Related
I am in a Intranet project for Global telehone Directory for my company.Is there is a solution in which we can connect to the microsoft mail exchange server and get a details of a employee through Outlook schedulewhether he/she is available or not.
View Replies
View Related
I would like to know if there is any way to schedule an asp page to run once a month.
The purpose of this process is to automatically insert data to a table in a monthly basis to allow users to manupilate it without having them to add any fields to the table.
View Replies
View Related
Is it possible with ASP to schedule tasks such as the following:
A database contains hundreds of registered users. Within three days of their registration expiry an email should be automatically generated to inform all relevant users that their account will expire shortly.
A sheduled task should also run every night (say, at midnight) to remove expired accounts from the system.
View Replies
View Related
I need to write one program to schedule the job to run the DTS created at SQL Server 2000 with Global Variable passing in every time when user select. I have search from internet, there only have example written in Visual Basic, can any body help me because my company not have Visual Basic.
And When I try to copy the example from VB Code to ASP code, there are error :
Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.
After I check is because of ProgID "SQLDMOUtil.Job" used in code.
View Replies
View Related
I have a pure asp (Vbscript) page that manipulates data between MSAccess and
SQLServer2000. I'm trying to use the Scheduler app on the IIS server to run
this page nightly but there must be a better way of doing this.
How can I make my code in to an object and install it on the server and have
it schedule to run nightly?
Below is the code:
View Replies
View Related
I am developing site in asp where I need to call a url at every interval. Is there a way to automate this. I want to call the url every 15 or 30 mins.
Cureently I have written a asp script tp call it using
Set objWinHttp = Server.CreateObject("WinHttp.WinHttpRequest.5.1")
objWinHttp.Open "GET",URL
objWinHttp.Send ' Send it.
strResponse3 = objWinHttp.ResponseText ' Get the response string from the object.
But it is not schedule..I can call it only when I rum the asp script. So is there any way I can schedule this url call for every 15/30 minutes.
Also forgot to mention : the site does not have that much traffic that I can add it in index page...there may be a user visiting the site in 5 hours time or within next 5 mins or for next 2 days there may be no visitor.
View Replies
View Related
I want to write a dll using VB6/VC6 and used by ASP. Questions are:
1. what special requirements for the dll used by ASP?
2. after built dll, how to use it in ASP? Where I should
save the dll? Do I need to register the dll?
Any article/link related to my question? the sample code?
View Replies
View Related
How to call VC++ DLL from ASP? Could any1 show me the way/coding step by step?
View Replies
View Related
I want to have a single script for sending emails, accessible from both
ASP pages in any virtual directory in our websites (all on the one
server), plus accessible from a number of WSH (windows scripting host
vbscript files) which are triggered by the web servers Scheduled tasks.
The script formats text and checks emails and so on.
Is this a candidate for a web service? if so, how would i write it? Is a
web service available from WSH?
View Replies
View Related
We have a C++ DLL that we call from VB6 program. This is how we declare the DLL in VB6:
Declare Function RefSearch Lib "csearch32.dll" (ByVal path As String, ByVal findword As String, ByVal CaseSensitive As Integer) As Integer This is how we call the DLL in VB6:
hit = RefSearch(path, SearchStr1, ChkValue). Can I call this DLL in ASP and how ?
View Replies
View Related
I have two .asp pages running under different IIS authentication methods..
The first page uses Windows Authentication and gets the Logged on User from
Request.ServerVariables("User_Logon")
The second page runs under different Domain credentials and can access the
ldap directory... so I want to call it like so..
user = request.servervariables("User_Logon")
then something like --
<%
call page2.asp?theuser=" & user"
%>
where page2 runs as 'anonymous' credentials... (and Logon_User is Null)
-------
If this can't be done can I write the information to a cookie and then read
it from the other asp? How would I do that?
View Replies
View Related
I just want to call two exe files from asp code.
View Replies
View Related
Does anyone try before using ASP to execute JOB in MSSQL?
View Replies
View Related
I have a bummer here. I have 3 sub R. that I need to call from a input button. I set up the following line, but the script just calls them with out having the button pressed. OOOO! Any ideas?
<form method="submit" name="nreg" onsubmit="(this)" action="call readitme, call saveitme, call reduce" >
I have also used method="POST" same darn thing, script just runs the sub R. with out being pushed or cliked. UUUGGG
View Replies
View Related
I have a form which checks email addresses. On submitting the form i have some JavaScript checking the format of the email address, once this has been completed successfully I would like my asp function to run. On successful completion of that I would like my form to be submitted to another page. Is this possible?
View Replies
View Related
This may be in the wrong forum, but I'm going to give it a shot anyways. Here goes.
I have a conference report that has 24 phone lines that are available for booking. Each call can take between 1-24 lines, you can have any number of calls as long as the number of lines they take up does not go over 24.
I graphiclly represent this in a horizontal bar graph that displays the number of lines that are taken up for a particular half hour.
Problem is when a meeting takes more than a half an hour, the meeting bar fills up for that whole time without any information on the meeting.
What I would like to do is have each meeting when assigned in the DB or through an array be assigned a color and then that color appears on the graph under the time the meeting is. If there are multiple meetings (there almost always are), then the meeting that has been active the longest will be the first color bar on the graph.
To make a way too long story short. I want to have a stacked bar chart that moves colors to the front as other's leave every half hour and move new ones to the back.
If you want to look at what we have now visit URL.
View Replies
View Related
Ok i'm self taught with regards to ASP so not great etc, so sorry if this is a really basic question..
On the last line here i'm trying to some how get it to call the last ID entry...
ImageID = Request("ID")
If (Len(ImageID) = 0) then ImageID = "1"
If Not IsNumeric(ImageID) Then ImageID = "1"
If ImageID = "0" then ImageID = "1"
If ImageID>3 then ImageID = max(Len(ImageID))
This is basically for some max min links for a online comic here's what it links to
<a href="default.asp?id=<%=ImageID-1%>">< Backwards</a> -
<a href="default.asp?id=<%=ImageID+1%>">Forward ></a> -
Code:
View Replies
View Related
Can i call function from dll from an asp page (not COM)?
The problem is that i want the asp page to call function from dll which will
be in the same folder.
I could have created a com dll but it means that the web hosting company
must register it on their server and they wont.
View Replies
View Related
My 1st page calls a 2nd that uses same data from a database. What is
the best way to get the data in the second: a new call to the database
or passing array through session variable??
I seems to me that avoiding a new call will speed up things but my
concerne is that I have read many posts with caution messages againts
session vars.
View Replies
View Related
How can I execute a console application (smsbr-con.exe) in the server from asp, insert the parameter (-c, -m, -n, etc.) and get a returned values.
View Replies
View Related
I've built an application in VB6 does some processing - it's not really
important what it does.
The application consists of a single DLL which does all the hard work, and a
simple EXE which acts as the front-end.
I designed it this way in the hope that I could also build an intranet app
that controls the same component (DLL).
I'm building the intranet page now, but I get this error when I try to
instantiate the component. Rather than fiddle aimlessly with the
permissions, I thought I'd post here and find out what I am missing.
What permissions do I need to set up and where?
View Replies
View Related
