Home | Advertising Info6 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Sunday, April 28, 2024  

  Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
SQL Queries
 PowerASP Code Help Area : SQL Queries
Subject Topic: Recordset on a embedded asp page via CDO Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
mjunior
Newbie
Newbie
Avatar

Joined: November/06/2004
Location: Brazil
Online Status: Offline
Posts: 27
Posted: December/28/2006 at 11:49am | IP Logged Quote mjunior
Hello,

I'm using CDO to send information by e-mail to the users of an intranet system.
By embedding a asp page via objMail.CreateMHTMLBody, I can send them dynamic content like info on db..
The point is: Since I tested and realized the embedded page can't perform a recordset to populate itself with db content, I'm sending this info as parameters and retrieving at the embeeded page before beeing attached on e-mail by quesrystring.
The tests I'm doing is gathering info from recordset (on a CDO page) like this:
Do while not rsemprestimos.eof

lista="Equipamento <b>"&rsemprestimos.fields("descricao")&"</b> - <b>"&rsemprestimos.fields("patrimonio")&" </b>emprestado em "&rsemprestimos.fields("data_empr")&" para o usuário <b>"& rsemprestimos.fields("usuario_atual")&"</b> <a href='http://192.168.53.20/telsul-controle/WebLab/renova_emp restimo.asp?equip_pat="&rsemprestimos.fields("patrimonio")&" '>renova r empréstimo</a><br>"
response.Write("<center>"&lista&"</center>")
msg=msg&lista
rsemprestimos.movenext
And then I send the cumulative info inside "msg" to the embedded page...

On my tests, when the msg size is too big (I could perform the CDO sending only up to 7 lines of recordset (each line has about 93 chars)) theres an error on objMail.CreateMHTMLBody line code which I realize is due the excessive amount of data.

Anyhow...I'd like to have suggestions from you guys on how to solve or at least increase the number os lines on recordset till the CDO crash.

Thanks in advance.

__________________
mjunior(dumb)
Back to Top View mjunior's Profile Search for other posts by mjunior
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

   Active Server Pages Rule The World
 Contact Us  
All artwork, design & content contained in this site are Copyright © 1998 - 2024 PowerASP.com and Christopher J. Williams
Banner ads ,other site logos, etc are copyright of their respective companies.
 STATS Unless otherwise noted - All Rights Reserved.

Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.cjwsoft.com,www.aspclassifieds.com,www.aspphotogallery.com