Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kennrosie
Starting Member
2 Posts |
 Posted - 2005-12-07 : 16:36:23
|
| Can some one give me an over view of what I need to do:Lets say I have a web form with the field: Arrival DateA web user enters an arrival date of 2/10/06How do I do a stored procedure that accepts that arrival date and lets me know (by an alert or email) 24 hrs in advance of the arrival date? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-12-07 : 19:36:02
|
| refer to [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=7824[/url]-----------------[KH] |
 |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2005-12-08 : 14:48:31
|
| Ur Q can be broken into 2 parts:1. How to send a parameter to a stored proc by a web page, and run that stored procedure2. How to automatically send an email from a SQL server by using some data in a table.Experiment on each.1. U have to select a web page building technology as ASP, JSP, PHP etc along with ADO / JDBC / ... to access the database from a web page.2. U should look in Books On Line and other materiel to find about mail sending from SQL Server.Once u find both, combine the 2.Good Luck |
|
|
|
|
|
|
Input on web form that updates Sql SERVER