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.
View RepliesI 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?
can i send a parameter to my asp page when a trigger event occured?
View Replies View RelatedI 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 was wondering if it is possible calling an ASP page automatically at a certain time. Kind of how a job is scheduled in SQL Server.
View Replies View RelatedI 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.
View Replies View RelatedIs there any way's to trigger a reguest to some URL (+ some parameters) with ASP code and wait for the response - similar to PHP's fopen
PS. response.redirect is not what I'm looking for.
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:
In the global.asa file, when does the Application_OnStart event trigger?
Is it:-
1. When the webserver starts or
2. When the website is first accessed AFTER the webserver has started.
Further to this when would the Application_OnEnd trigger?
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 this possible?
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.
View Replies View RelatedI can trigger these events successfully if table only has one row:
Sub InputField_OnChange()
......
End Sub
But, these events cannot be fired if table has more than one row, why?