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 |
|
Limuh
Yak Posting Veteran
94 Posts |
 Posted - 2008-05-07 : 05:58:37
|
| hello im trying to update the notification by yes or no using stored procedure when the email is sent to the user. the sending o email is being accomplish using SendEmail Class. the send email class will return success and error if success or error the stored procedure will run and update the notification.My question is how can i get the return value of that SendEmail class and how can i connect those two task? Please Help.. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-07 : 06:11:06
|
| I dunno, do you have an output variable in your sendemail class? |
 |
|
|
Limuh
Yak Posting Veteran
94 Posts |
Posted - 2008-05-07 : 06:50:20
|
| the send email class will pass me an ID like "1", "2",..etc and i need to update the input using stored procedure |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-07 : 06:53:54
|
| What does 1,2, etc mean though? |
|
|
|
Limuh
Yak Posting Veteran
94 Posts |
Posted - 2008-05-07 : 07:31:12
|
| that is the values of the ID Feilds |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-07 : 08:52:41
|
Sorry? I think you will have to explain more about what your class does and what you are after from the stored procedure. How do you know if the class has been sucessful? If it by the ID that is passed back, then as long as anything is passed back you can run a simple update, such as:update <table>set <field> = 'Done it'where <field> = <value> As you have given no structure and only a partial explanation of what you want, there is not much more help I or anyone here can give you, please refer to the FAQs and post some DDL and samples. |
|
|
|
|
|
|
Updating Notification stored proc