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?
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 RelatedI'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 Relatedi need to create a xml file with asp. I think i can handle that part but before i start is there a way to create an xml then have it upload that file when it's not really creating a new page? hopfully that makes sense. so i need to create a xml file with asp then upload it to an ftp using asp.
View Replies View RelatedI have a problem. I have a database with 1000 e-mails that i use in my
mailinglist. And when i send them mails it takes kinda long since i attach a
..pdf file each time. so i was wondering if there is a way in asp to create a
task on the webserver using asp to trigger a script that sends the mails.
sure i could use server.scripttimeout but the thing is that i dont want to
wait 30 seconds for the page to finish loading. and if there will be 3000 in
near future i'll have to wait for a very loooooong time.
anyone know how to create a task using asp dynamically?
you have a DB that contains about 2000 records.
Assume that the records are houses with addresses, already known to the user,
[remember, there are rooms, bathrooms fireplaces, garages etc].
What I want is this:
A user enters a known address in the form. The form seaches the DB and returns the address with full details.
That is, search results will be like,
Address 1234, number of rooms 3, bathrooms 3 etc.
If the address the user seached for is not found, the user is redirected to a page that prompts them to add it
to the DB. Also I would like for it [search results] to open in a mini window with an option for the user to close window after reviewing the records.
I have thought of using a drop-down but discarded that, 'cos what happens if the DB records gets to be in the thousands?
I am attempting to design a maintenance program which includes a series of recurring tasks. I would like for the user to be able to assign their tasks to recur similar to the way Outlook does.
I have been searching on the web for quite a while and have been unsuccessful with getting ideas on how to start this. I would like to use ASP VB or JavaScript.
Does anyone have any suggestions or links that could point me in the right direction?
i want to print a string (that i retrieve from database field), that contains say 60 lines, then i want to insert a page break and a common header for each page.
View Replies View RelatedI want is to have my asp code test if it is the first time the page has loaded. If so it will need to skip my validation info, if not then run the validation code:
View Replies View RelatedI want to send email atomatically everyday.I tried using the scheduled task but when I typed in the URL i the "Run" textfield,the scheduler could not start.Anyone knows why?
View Replies View RelatedI need an end task program in VB6.0 (the source code). I have searched planet-source-code.com inside out and can't find just 1 regular end task program that works on my system. Is it because I am running on XP and they only work on ME and younger systems?
Anyways I need an XP, source, compatible version of the software. I am writing an interesting program, which once complete will tell you what its for (dont worry this one is totally legal ). It should list and then allow users to click END/close. I think its done through an API.
I have an ASP application which includes an asp page which
processes a user submitted file. I would like to
automate the process so the server scans the directory
every 5 minutes and processes any files in the directory.
I would like to 'reuse' the existing logic in the asp
page.
How can I create a server process to do this?
The closest I can figure out is to hook the logic into a
application/session start logic in global.asa where it
would run everytime a new session was started, but I would
like it to run like a cron job every 5 minutes. Code:
I have a table which stores details of businesses. These businesses have associated links to 2 tables called areas and categories. What I would like to be able to do is display a list of all the businesses in a particular area with a breakdown of all the different categories in that area together with a corresponding count of records.
i.e. pull out all the businesses for a given area and order by business category
then for each category, display a count of the records in that particular category in that area.
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 RelatedIs it possible to run an asp page as a scheduled task?
View Replies View RelatedDoes anyone know if its possible to send an Outlook task from an ASP page running on a Windows 2000 Server on an intranet. There is also Microsoft Exchange Server on the same network which handles Outlook mailboxes.
The Windows 2000 server will soon be upgraded to Wndows 2003, if that makes a difference.
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 RelatedHow 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().
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
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?
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 RelatedI wanted to run an ASP script to send mails, to be executed every 24 Hours.
View Replies View RelatedIs it possible to create an outlook task item from ASP? I tried using server.createobject("Outlook.application") but the page just hangs without output. I use CDO.message for mails.
View Replies View RelatedI 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?
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 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 RelatedI 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.
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.
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.
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:
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.