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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-30 : 09:31:49
|
| Curt writes "Hi,Is there a way to repeat a recordset and mail the results in CDONTS? Basically, I have an order form and want the multiple items, which are pulled from the SQL Server database, to be inserted into the body portion of the email. Looks like CDONTS doesn't support most vbscript and ASP commands, so I'm stumped. Any suggestions appreciated!Thanks,Curt" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-11-30 : 15:18:05
|
| I don't know of any CDONTS methods that will query the database for a recordset, if that's what you're looking for.CDONTS is a COM object (.dll) and as such does not accept programming commands. It does have built-in functions (methods) that you can execute, but if you're looking to put something in the body of the email, you need to build it as a text string, and then assign it to the obj.Body parameter.-------------------It's a SQL thing... |
 |
|
|
|
|
|
Looping or repeating recordsets in CDONTS