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 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 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:
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?
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'm using Javascript for my site, using Dreamweaver to create the pages. On my SQL Server I have created a DTS package that first recreates a table and then imports an Excel file.
I have created a Stored Procedure to launch this package. This part works great if launched from Query Analyzer. I want a user to be able to push a button which will launch the Stored Procedure and then return the results of how many records were imported.
From an asp page, i'm trying to auto-open a pop-up page if something exists. I can do this within access via vba using below code.
Anyone know how I could modify the below js to auto-lauch from asp?
sPage = "javascript:
resizeTo(478,500);moveTo(130,150);document.locatio n.href='http://myserver/myweb/mypopup.asp"
sApp = "c:Program FilesInternet Exploreriexplore.exe"
sCommand = sApp & " " & sPage & "'"
Call Shell(sCommand, 1)
I work on an existing application in ASP, which requires an access to DBAccess. I work on Win2K Professional and launch ISS. I have created both an administrator and a user count. The fact is that I can't launch ASP file in a browser. It results in asking me whether I want to register the file or whether I want to open it with an application on the hard disk.
I use FrontPage to edit ASP files. Using this software allows me to see the result of html but not the results of query (using DBAccess). I have yet declared an ODBC source refering to my Access database. I have also nstalled IIS.
But I can launch it only when Administrator!?? I have declared a virtual path to my web pages. But impossible to attain them in Netscape or IE.
I'd like to launch an executable file from a web page. Basically, the user
enters seven parameters and then clicks a button to generate a graph. The
input is written to a file and then read by the exe. The exe then generates
a graph based upon the input parameters.
I am reading about the Process class and wondering if that is the best
approach to this. Can you recommend a KB article?
I'm writing an intranet-only browser based application. I need to launch either a SETUP.EXE that is on a network drive or a shortcut on a local drive that points to the exe on the network drive
I already know how to launch a local exe, for example:
Set objApp = CreateObject("WScript.Shell")
objApp.Run "cmd /C CD C: & Program Files & SomeFolder & SETUP"
I want to add an 'edit' link next to certain images that appears in my ASP application. When this link is clicked I want it to open an editor such as PhotoShop or MS Office Picture Manager with the picture. The only thing i can get it to do is to display the picture in the browser or ask me to download or execute the program.
I did some searching but couldn't find anything to help. It looks like other users with similar questions just gave up.
I want to use vbscript to run a script multiple times and save its results to a text file. I have practically wrote this script before but only using a sql command wrote in to the script. However, this is a lengthy sql file so can not be directly entered in to the vbs script,s o I would like to run it using sqlcmd.
"SQLCMD -S "&WScript.Arguments(0)&" -i "&WScript.Arguments(1)
I have tried Googling this problem but found very little information about it. Any discussions online that I have found show no code and assume you already know how to do it.
I have found this so far:
Set objShell = CreateObject("WScript.Shell")
Set objScriptExec = objShell.Exec("sqlcmd -S "&WScript.Arguments(0)&" -i "&WScript.Arguments(1))
But how do I get hold of the results in to some kind of variable?
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 .
I need some free tools that would allow me to automatically send e-mails to somebody acoording to the current date (e.g. if I have a table in a database with some fellows and their birthdays, I would like to automatically send them a greeting e-mail, when their birthday is). I would preffer that tool be installed as a service.
It will be just fine if I will be able to use this tool in an ASP site.
Otherwise, how could I program such a tool (and what language would be the most appropriate)?