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 |
|
swhitworth
Starting Member
1 Post |
 Posted - 2002-08-19 : 12:14:34
|
| HiI have worked through the solution and got it working for SQL7. However where you write the @body content for the email I want to add the results of an SQL statement in to html formatted email.Basically it would look something like this.....Can do similar things OK in asp but cant get the same results here.'<body><font size="2"><a href=http://www.mysite.com/news.asp?id='(PRID)'>'(PRTitle)'</a></font>'Would also want to loop through the recordset.Afraid I'm a bit of an amateur with SQL and cant get it to work - any tips gratefully received..<edit> moved to correct forum </edit>Edited by - robvolk on 08/19/2002 12:46:52 |
|
|
|
|
|
Adding recordset results