I have created a table called as 'usertable' in ms sql database. The columns in 'usertable' are username, loginid, password. The record gets added to this table, when a new user makes a fresh registration.
So My question is whenever a new user is added to a table, an automatic mail should come to me 'pra123@yahoo.com' mentioning that a new user is added to table ALONG WITH HIS USERNAME, LOGINID, PASSWORD.
All this information should come to my email account automatically. So how to write ASP Code for this.
I have a database that displays an editable record, with buttons for changing to different records. I was wondering if there was a way to store a template email, and have a link on the page that, when clicked, fills the records info into the email and sends it?
I want to send customers and automatecly generated email once they submit a form/place order. I've been searching the net for a whille but I haven't been able to find any usefull information.
I'm trying to write a script that will send a automatic email either on loading the thanks you for ordering page. or the one before that where the order is placed pressing a order now button, it can only be send when the button is pressed and the order has been placed in the database.
Now I've writen a test script to figure out how this whole automatic emailing works but I can't get it to work. I hope someone can tell me what is wrong. Code:
When some visitor come to my form.html page he/she needs to submit his/her name and e-mail address and then click submit button to be redirected to say thankyou.html.
Now i would like to email the user instantly when he/she submit the form ( he basically get automatic response ) with e-mail message like " Thank you for submiting those infos ".
I just don't know the code for that and please provide me with some examples.
After all i would like to check that script in iis 5.1 with SMTP server on win xp to be sure that everything work if it's possible.
I'm developing an application which has subscribers entered into a SQL Server database.
Their subscription is monthly, and requires that automatic emails are triggered 1 week, 2 days then 1 day before their subscription expires.
How would this be best done?
I've heard of third party cron services which could be used to trigger a script, but the script would then need to be 'open' to the web for the cron service to access it - which is not very secure.
The other option would be to trigger emails from the database directly, but I'm a total beginner at SQL so am not sure how difficult this would be?
I need to some how do the following and if anyone can help me or point me in the right direction I would appreciate it very much.
I have a form that the user would fill out. When he/she clicks submit it goes into another page that reviews the information that the user typed in the previous form. If all of the information is good for the user there's another button in that page that they would have to click.
This is what I want to happen after they click on this button. I want to record the data in a SQL database, which I know how to do that, but what I want to happen automatically right after inserting the data in the SQL database is that I want the same data to be carried over to another page where there'll be another form and want that data to be populated in this new form. How do I do that?
is it possiable in run some automatic checkups on the server every X time or every time (with no reaction with the user). I need to run all the time checkups on the sql database and check values of some column.
I would like to backup the Remote Access database from a link on my asp application . Is it possible ?For instance, there would be a menu which once clicked will initiate login/password and ftp server, get the database and rename it with currentdate, close the connexion ?
I want to add code to the URL so on click will be performed login action with some username and password (ex. h t t p : / / w w w . s o m e - s i t e . c o m /login&username=USER&password=PASS)
I think I wrote total nonsense, but I think you know what I am talking about
If someone want to help me here is that site I want to perform auto login: ...
if there is a way to have a page print automatically, with no dialog box when the page loads, using VBScript or Javascript. This will be an intranet application, running in IE6. I will have control over the browser settings, so those wont be a problem.
As u see that in yahoo messanger it provide facility for auto fill login and password for specific system. If we want to see our yahoo messanger in my personal sysem then we dont require to fill this user id and password. It automatically fills user id and password. I want to do it in asp.
Is there any way to create automatic generation number like, INW001.......INW002.... ans so on without using any code in ms-access using "autonumber" type with default value.
or
Can you give me the code for creating automatic generation of numbers for a column IDNO , using alphanumeric.
Eg: INW001 , Next should be INW002 ,....... INW010 and so on
where I can get a script which will automatically print a page when its entered or when a form has been submitted. Ive tried to find a script to do such a fing but I really cant find anything to support it.
Is there a way to automatically execute code in ASP? I need to send reminders for one my applications and need some suggestions . how I can send reminder emails automatically.
I want to know if there is a possibility of mailing the iis log files automatically,say on a daily basis. The problem i am facing now is that my web host is very busy and i need to send dozens of mails to remind him. Also tell me the security previlages needed to execute the script so that i can convey the same to my web host....
And last but not the least can we develop this script with windows nt workstation + iis 4 wihout smtp.
I have created a Store front with .asp & access and I would like to setup something that emails all my users on my mailing list with a Dymanic email with the weeks specials.
But I would like it to happen automatically without any user interaction, say I would like to send it all the users @ 12.00am every monday.
I am having problems sending emails via the CDO.Message object from an ASP script which was working fine. On the server I can still send emails via the CDO.Message from a .vbs script executed on the desktop. If I pause the SMTP service I can see mails queuing up from the .vbs script but the ASP script no longer generates emails, nor does it error when it creates the object. Could this be a permissions problem? No IIS settings have changed, but the server downloads automatic Windows updates.
I need to build code to download automatically image to my local disk. somethink like i will specify url in code and it fetches image from that location and save in my local disk. for example http://www.xyz.com/images/test.jpg and it will store test.jpg in my local folder. how to achieve this?
my problem is i want to retrieve/get the date 3 day early using asp code, for example this date 12/10/2004 and i want to know 3 day early from that date which is 9/10/2004, do u guys have any idea....
and i more question which is how to make a page automatically run a program when the time or date is set, after the time/date has expire then a program is run, i have no idea also.
I currently have my asp page firing off an email from outlook to confirm a booking. I would like it to fire a meeting request instead so that the recipient can accept the meeting request and it will show in their outlook calendar. Is this possible? Code:
if anyone had any script that can allow a page to run some code and then kick off a file download.Maybe like many places do saying download should start automatically or you can "click here".I appologise if this is easy to work out from the source of one of those pages, but my view source seems to have died and I thought an answer from here might be quicker than fixing it!
Posting variables from an HTML FORM, via the Request.Form function on the receiving ASP page is great. But how can you POST a Form variable to an ASP page -- without a human pushing a Submit button? An ASP page that can decide when to POST and send the Form vaiables, but out without a human in the loop.p.s. the reason I do not want to use a Request.Querysting is because I do not want the user to see the values at the tail-end of the URL (?x=private).
In my application, the main page is accessed via a login screen. A particular record is accessed based on the value of login page. Everything works fine. However, if this screen is kept idle (not sure for how long now), and then if I try to save,the following error message comes up:
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'SubgrantIntID ='. /gwisbrandnewready2/insertorupdatecurrentexpense1.asp, line 32
Is there any way to code to get one logged out automatically after sometime, so that, I do not have to encounter the above error which means after sometime, the login screen will appear instead. Does the custom timeout override the server default timeout?
I have a web page with three fields, Name and designation, salary. The name field is a <select> tag which contains all the names present in a tabe. When I select a name, the corresponding designation should be displayed. Then I enter salary and submit the form. There are two submts involved?
I've read the thread on how to design an automatic email reminder system, but does anyone have any tutorials or code on how to set it up using Access 2000 and/or SQL Server?
There are no articles on the net (that I could find) related to automatically sending a user an email at a set date and time from 1 table of a database.
From what I can gather, I may need to use a stored procedure, but there's no tutorial on how to design or implement this.
