I have an ASP page which checks some condition from database and based on that it sends mails to respective persons. All mail details is in SQL server. The page works perfectly fine.
What i need is this page has to be executed daily without the interaction of any user/administrator. Is it possible?
I need to set up an asp script that will be run at the beginning of each day. How can I get this page to be opened at a certain time each day?
BTW - My page is to update a database, where based on a timestamp stored in the database, will deem records valid or invalid.
Is there any script which can delete a webpage after a given time-period within that script?
I want a page to be deleted after a desired time and to not work untill reupload or recode.
I would like to run an ASP page each day at the same time automatically. it reads from my product data and ftps the data to another server.
I am running on a windows system with IIS I have no idea where to begin. Is there anything else I can do? it is not my own server so I don't have access to server. I can just ftp.
I have an ASP page that displays random facts. Data is stored in a database. Everytime user hits on refresh, randomize function shows a new fact. I would like my asp page to refresh automatically every minute or so and run the randomize funtion and show a new fact. Is it possible with ASP? I have seen it done with Flash.
View Replies View Relatedhow can i jump directly to another page ? let me explain better...i've got this form...the user fullfills the form and presses send...the form calls and asp file...after executing that file i want to be able to send the user to a specific web page, but i don't want him to press any link...just go there directly...how can i do it ?
View Replies View RelatedI have a page that allows user input. On click of the submit button I call a javascript function that verifies that all of the fields are filled out and then submits the form. I need to add code after the verification that creates and sends an email. I know how to do this in VBscript, but don't know how to call a vbscript function from a jscript function (is this even possible?).
View Replies View RelatedMy boss wants me to develop this page so that users can click on a button alongside an employee's page and this will open up the company Expenses Claim Form with some of the fields automatically filled in, pulled from the same SQL database that the webpage gets its info from.
I have been looking this up for *weeks* now, but the only solutions I can see involve the dot net framework, 3rd-party plug-ins or installing the Microsoft ODBC driver for Excel. My boss will not accept any of these solutions, as we are a huge organisation and this has to work accross the entire system. We're stuck with MS Office 2002, Windows XP and SQL Server 2000.
So far the best I can manage is getting the Excel form to open (but without the fields filled in), which I accomplish using the following code:
is there a way in ASP to automatically submit a form and its values when a page loads ?
if not is there any way round this scenario. i want to have a drop down list of options depending on which is selected will depend on where the form is submitted to.
what I want to do is - the user is presented with a form with a drop down box at the top with two options - Yes or No, If No is selected then the form stays as is and the user can complete the other text boxes.
However, if the user selects yes I want the page to refresh with a different set of input boxes.
I am hosting a website on Windows 2003 server, IS6, MS SQL Server. I
have one ASP file I would like to run daily. How can I do it if I do
not have acces to OS's management (to use, for example, task scheduler)
and I do not want to include this page within other pages of the
website to be run (because that may slow down the page loading for
users)?
I'm trying to execute ASPX page on a test IIS Server. Instead of executing it shows the ASPX file on screen.
View Replies View RelatedI need to come with some ASP code that can select a new record out of the database as a sort of "tip of the day". However I want it to do this randomly and daily, I do not wish to have to set a display date or whatever. I am going to use it on my website as a "tip of the day" section however I want to be able to input 100 records at one time and just let it randomly choose one everyday.
View Replies View RelatedI have an ASP page which does access a table in the database. I get the following error when i try to access the page:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Unknown
/school/admin/queryMainMenuItems.asp, line 38
The error happens when the SQL statement is being executed. There is nothing wrong with my code as it works fine in another PC. The strange thing is that when i open the database and double click on the tables, it simply shows an Message Box with the message "Unknown".
using classic asp and COMless scripting, is there a way for the asp on a server to automatically perform a function on a scheduled time, im thinking of things like database replication, clearing old data etc.
View Replies View RelatedI have a pop-up window with a search button. If click on this button then a record list is made on this pop-up window. Each record have field with a href link. If you click on the href link next function is executed: Code:
View Replies View RelatedI need no send birthday emails every day. I need something to check everyday on my database for birthdays, but I don't have any components to do that and I dont have rights to install it on my webserver.
Is there a way to do it without installing anything? Only through asp?
I'm trying to run the server.execute command inside a executed file. It doesn't work. Can anybody tell me why? I've searched all around and haven't found a reason. Could it be because it's not supose to work, or is the syntax diferent then in the first file?
It's something like this:
File 1
...
<%Server.Execute("File2.asp")%>
...
File 2
...
<%Server.Execute("file3.asp")%>
...
File 3
<HTML>
<body>
Hello!
</body>
</HTML>
Is this possible?
I have asp code. I would like to run it automatically by time interval using wondow schedule, but it can not be excuted. Is the reason that ASP is not executable? If so, how to run asp using window schedule?
View Replies View RelatedI'd like to set-up an ASP page that emails shoppers 30 days after they've purchased an online product.
Constructing an ASP page that searches the database and if the datediff of the order date and now() = 30 to send out an email shouldn't be that difficult. But is there a way to have it run automatically?
when write open asp code in front page it automatically insert a </formtag in appropriate place. what is its cause and how to stop it.
View Replies View Relatedhow do i automatically delete records on date submitted
View Replies View Relatedif there is a way to use asp to automatically (i.e each time the source table is updated) take data from one table in an access database and add it to another table.
This would include getting data from multiple columns in the source table and concatenating it into one in the destination table.
Pls what code can i use to automatically close and asp page after execution.
View Replies View RelatedI am building a database that users will update.
I have a table named "products".
Every product has a shelf life of 3 years and expires exactely at the end of the 3rd year.
Here is my table:
Productid ---- int
productName ---- varchar
manufacture_date ----- datetime default (getdate)
Expire_date ----- datetime
What I want is this, whenever a product is entered, the defualt date is the date the entry
was made. (I am using the "getdate") to automatically grab this.
BUT I also want the "Expire_date" field automatically calculated and then filled in.
That is, a user enters a product "manufacture_date" as 05/22/2003,
Then I want the expire field to be filled with 05/22/2006.
My preference is to handle this on the DB site and not ASP.
To create a asp file in a wbserver as a interface for the IPphone and the internet. As IPphone can only have GET function ( that means it can't POST thing to the internet).
The asp file's concept is that the file is firstly read the data sent by the IPphone and then encode them into html format and then POST them to the required website. However, i only know the following method to POST. Code:
Let's say i have a text file on the web server callled "text.txt". And I have another text file on my computer called "text2.txt". I want to somehow write the contents of "text2.txt" into "text.txt". (or even upload the file from my computer to the web server)
View Replies View Relatedi have 3 textfields: txtPrice, txtQty and txtSubPrice.
price for an item will be fetched from db at display in the txtPrice (i can do this). then, user just key-in the quantity for the item and automatically the sub price will appear in the txtSubPrice.
i have coded a function name CalculateSub() using javascript and tried to do the automatically calculation using onClick and onFocus at the txtSubPrice but failed. seems like textfield cannot has this function.
I have a problem with IIS 6.0 + IE 6.0. I'm POSTing back to an ASP page a long lists of IDs used for sending emails (>10.000). This process takes more than 30 min. The problem is that this process is automatically restarted by posting again all the data. I checked ASP page and there is nothing to reload the page. But after more than 30 min. (changed the timeouts) the process simply restarts by posting again the full list. I only need to
execute this page once.
why the whole process restarts posting back data (is not a simply GET, but POST)? There is no F5 / CTRL-F5 or Back buttons. It simply re-post data, without an error. It's my ASP page wrong? Or something wrong with IIS?
I want to add in my website a share rate and which changes automatically. how can i dispaly it in website what i have to do for that. I dont want to be linked with its website bu t i want to be displayed it in my web site.
View Replies View RelatedIIS in our server is shutting down automatically on its own. I don't know what is the problem?
View Replies View RelatedI have created an application in ASP and want ot install the same into another machine but want to do in a manner such that all the programms should automatically install in InetPub directory.
I can think of executing this by cretaing an exec which will identify the inetpub and then installing the programms into it.
This is the message i get when we have our application running using our own ISAPI code, it desapears when we don use the ISAPI filter, Can anyone help, It seems IIS assumes that we have a virus as stated by microsoft Message
IIS ADMIN SERVICE TERMINATED UEXPECTEDLY XTIMES EVENT ID
7031
SMTP SERVICE TERMINATED UNEXPECTEDLY XTIMES EVENT ID 7031
FTP SERVICE TERMINATED UNEXPECTEDLY XTIMES EVENT ID 7031
It only happens when we are using our own ISAPI FILTERS .