I have access to an ASP based system where a supervisor has to periodically
"press the button" to generate a list based on a database held behind the
webserver. Unfortunately, people being what they are, this is sometimes
forgotten so I'm investigating whether this can be automated.
My hands are tied slightly in that I can access the webpages themselves,
most of which contain ASP, and I can run something on the surpervisor's PC,
for example via "Task Scheduler" to download pages. But what tool should I
use? I can't see any way of triggering Internet Explorer is "automated
mode" to just trigger the page so is there some tool specifically designed
for this job? Code:
http://www.aspfaq.com/show.asp?id=2143, which led to this article on using a SQL Server job: http://www.aspfaq.com/show.asp?id=2403
Here's my question: I have an intranet app which tracks tickets for tech support. The boss wants it so that, depending on the severity of the ticket, we go into the DB and check every 15 minutes or so to see if the ticket is being handled. If no activity is detected in an accepted amount of time, then an email gets sent automatically to certain managers, The first article cited above gives 4 options, and the last two aren't possibilities in my case. I'm leaning toward option 2, which is the SQL job, but will take advice.
I want to perform the simple task of running an ASP script as a scheduled job.
Previously I've always either run a .vbs script via windows Scheduler, or put some logic in my global.asa, both of which have worked fine.
Unfortunately there are technical reasons (too complicated to go into here) which mean I can't use either the global.asa or a standalone vbs script for this job. It really does have to be an .asp script running in the application space.
Running a scheduled job that runs the command "explorer http://www.mydomain.com/myscript.asp" does the job, but will leave a new window open every day, which will cause problems when sat on a remote server. (self.close() at the end of the script just gives the "app trying to close window" message and leaves window open)
Does anyone have any suggestions as to how to achieve this on a W2K server?
Some kind of opening IE, running script, closing IE via VBS maybe?
I 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?
How would I go about running a script on my server every hour? Say I save it as http://www.mydomain.com/script.asp . Is there anyway I could get it to trigger once an hour?
We wanna develop a SMS and email reminder. The users can set date and time and reminder msg, it can be monthly, daily or weekly. We need to send sms at the scheduled time, so please kindly advise me what is the best method i can do, by creating an ActiveX component in VB or developing dll in ASP or any other best way.
The only thing coming to my mind is there should be some application running continously on the server, by the way do we really need to have one dedicated server? We have to run the script for every 5 or 10 minutes. I think we can do this by task scheduler or with any service, but which will be best for better performance?
I need 2 colums of one table to equal the value of 2 columns on another table any time data is inserted there. Never messed with a trigger before so I'm want to get help so I dont screw something up.
table - dbo.lotinfo
column - idrma column - idlot
table - dbo.lotbd
column - idrma column - idlot
anytime lotinfo has data inserted in the above columns I need the respective columns in lotbd to equal the same thing automatically.
Any professional advise out there for a begginer with this subject?
I did read Andrew's article about SQL Server trigger. After a 'Insert' trigger is fired,is there any way we can modify newly added data in virtual 'Insert' table before put them to the database?
I don't think this is possible, but thought I would ask. Is there a way to trigger an onChange event. I have a couple of radio buttons and use ASP to change them at somepoint. When it does I want to trigger the onChange.
How would i go about triggering a script to run automatically every so many days on my server? Is there somekind of clock or timer function that i could use to trigger an asp script to run on my server every so many days without my intervention? This would be for database cleaning and a few other things.
I am studying Programming and Computer Engineering and got an assignment. I made a lamp kit and a program, but I now need to integrate both by using ASP. So, when somebody is in the ASP page and presses a certain button, the lamp needs to automatically switch on (or off).
This of course not only applies to a lamp but should be used for different devices. The logic is that no matter where you are or what time it is, you can remotely switch devices on or off using ASP.
My question is: What codes do I need to make this work? And what are the steps to follow?
I want to put insert trigger on my sql server database and showing the error result on invalid insert on the ASP page that is trying to insert the record.
Is there away to capture a session variable value from IIS and use it in a SQL 2000 trigger with out passing it as a part of a string query. I just want to capture it somehow systemically.
I created a web page from Excel2000, using "Save as web page..."...Publish function. then, I moved htm file to my IIS web server. Then I added a form control, and submit button.
How can get the data on the excel file using ASP from server side? For example, the value of Cell(1,2), Cell(2,3)....
What I want to be able to do is create a user control that will display an entire page page within it. Does anyone know how to do this or better yet have any same code?
I like to know how to write this specifc function on ASP where the user eg: display a set of records on the webpage. Example the data are ID, Name and address.
Lets say i display the data on the webpage and i set the Name as the <a href>. So when i click on the name, it will move to another page with the id of the specific name. Code:
I have an ActiveX control in my ASP page that has not been signed yet, so currently just for testing I set the Security for Intranet to "Low". When I run the ASP page on my machine (the IIS is in my machine), I have no problem, except the page prompted me with "An ActiveX control on this page might be unsafe to interact with other parts of the page. Do you want to allow this interaction?"
But, when I run the ASP page on another machine (even though the other machine is also a development machine that already has the ActiveX control and I set the Security for Intranet to "Low"), it did not prompt me the above message, and I got an error when accesing any method of the AX control (e.g Object doesn't support this property or method 'myAXControl.method').
Is this because I have to create a CAB file and mark the AX control as safe for scripting ?To create a CAB file for this AX control, do I need to create my own VB AX Control project that contains this control and then create a cab file for this VB project ?
This is a standard ASP application that has several pages at the root withthe global.asa. I set a session variable session("accountid") = "123456" within an asp page and then response.redirect to the next page and immediately response.write session("accountid") and I get back nothing.
But if I set a session variable session("accountid") = "123456" within an asp page and response.redirect to a page in a sub directory and immediately response.write session("accountid") I get back 123456 on the screen.
I am having a problem with a site that I am developing - my aim is for it to validate as XHTML Strict however, I am running into a couple of problems validating it; in my Response.Write ASP script, I am not including " 's to define page element tags as they keep throwing up errors in the page. Code:
I've a strange problem with Windows Vista, running an ASP page on local machine (http://localhost/test.asp), the page does not give me any error but the asp code is not executed (simple code : <% response.write("hello") %), it show me a blank page, I think I've put all the setttings correctly, but maybe I must do something obvious to fix that.
I encounter a page reload situation in ASP. It is I need a way to differentiate whether the current page - "Application_Result.asp" got reloaded itself when user click on the browserRefresh button or is requested by the previous page "Application_Form.asp".
I tried using <%if Request.ServerVariables("REQUEST_METHOD") = "POST" then%> <!--it is requested from "Application_Form.asp, do something--> <%else%> <!--Application_Result.asp refreshed itself(such as user clicks on the browser Refresh button, do something else--> <%end if%>
However, in both cases, the IF statement above all evaluated as true. how to differentiate this two different behavior (Page Refresh versus Page requested by another Page) ?
I have page for user to update his/her details. What i want is after idle for more than 20 mins, the page will redirect to login page automatically. So that the user knows that his/her session already expired and need to login again.
But it doesn't working. This is because if he/she update the details (after idle more than 20 mins), and click the Submit button, it will go to login page and all the data will be lost. Code:
I am working with a developer, on two portions to a site, he is working in PHP and my work is done in ASP.
Is it possible for my pages to request data from a cookie that was written by his pages that are PHP but residing on the same server? Just want to make sure before I spend too much time planning out the development on my end.
I have an application which allow users to search our database. Quite a lot of search fields pull data from other tables. I don't want to populate the dropdowns (total 14 of them) from the database everytime as it slow the page load.
Instead I would like to have a link next to the text field which a user and click and the choices can be displayed and whatever the user click in the pop up I want to transfer it to the text box and close the popup.
For example there is a Textbox called country. The user can either type in the country name or click on the link which will pull all the countries from table in the database and which ever country user selects, the textbox is popluated with the country name and the pop up closes automatically. Code:
I'm trying to write an asp page line by line, as one would create a text file, only my file will end in .asp.
One line simply writes a close ASP code tag, or
FILECONTENTS=FILECONTENTS & "%>"
When this line processed, an error occurs saying that the string was never terminated because the asp page attempting to write this line of code to a NEW asp page reads that close ASP tag (%>), as an actual close asp tag for itself, instead of a STRING value.
How do I write this %> symbol to a new asp file, while still maintaining its purpose to close a group of asp code in the newly created page?
But as i carry some data from previous previous page, when i use (window.opener.location = window.opener.location), it can't capture my data as it just load the page. It will pop up error as no data captured :
Microsoft VBScript runtime error '800a000d' Type mismatch: '[string: ""]'
