Home | Advertising Info164 USERS CURRENTLY ONLINE   
   Site Search Contact Us Saturday, July 02, 2022  

  Active InfoActive Info  Display List of Info MembersMemberlist  Search The InfoSearch  HelpHelp
  RegisterRegister  LoginLogin
SQL Queries
 PowerASP Code Help Area : SQL Queries
Subject Info: Recordset on a embedded asp page via CDO A d d  -  P o s tAdd P o s t
Message << Prev Info | Next Info >>

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


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=' restimo.asp?equip_pat="&rsemprestimos.fields("patrimonio")&" '>renova r empréstimo</a><br>"
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.

Back to Top View mjunior's Profile Search for other info by mjunior

If you wish to make a comment to this info you must first login
If you are not already registered you must first register

  A d d  -  P o s tAdd P o s t
Printable version Printable version

Info Jump
You cannot add new info in this area
You cannot add to info in this area
You cannot delete your info in this area
You cannot edit your info in this area
You cannot create polls in this area
You cannot vote in polls in this area

   Active Server Pages Rule The World
Contact Us  
All artwork, design & content contained in this site are Copyright © 1998 - 2022 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 ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.cjwsoft.com,www.aspclassifieds.com,www.aspphotogallery.com