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 |
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
 Posted - 2000-08-19 : 15:21:47
|
| nilesh patel writes "Hello sir,since last more than one month i have one problem due to which i cannot launch my Greeting card application. i have developed E-Greeting Card application using ASP,CDONT Object with IIS 4.0 Web server and MS SQL7.0 as a database server.In SQL Database i used Table Name "greeting" with Fields sendername, recipientname,senderemail,recipientemail,subject,message,imagepath,senddate,currentdate.Here senddate field will store date of greeting when it will send.Now suppose anybody prepare to send greetingCard at a time then Its a no problem Its work successfully and i store that card in database for 1 month.But Now the problem is as follow :-For example Suppose Your birthday is in December on date 25th. and i will prepare your birthdate Greeting card today but i will set the date 12/25/2000 (mm/dd/yyyy) to send the greeting card to you. so, you will get that Birthday Greeting on 12/25/2000(mm/dd/yyyy). i store all this data in database.Upto this time Everything is working perfectly. Now problem is On that perticular date how to send or fire that Greeting card from table fields in whichGreeting Card mail will be fired from senderemail to recipientemail fields with appropriate messages, subject,imagepath,etc.In summary, the problem is How to send email on Perticualr date within database in which senderemail and recipientemail are also fields of that table in Databse using MS SQL 7.0?Please Give me solution. Waiting for Prompt Reply. Regards.nilesh patel " |
|
|
|
|
|
|
|
Mail within Table Fields in MS SQL 7.0