Home | Advertising Info19 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Friday, March 29, 2024  

  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
Author
Message << Prev Info | Next Info >>
mjunior
Newbie
Newbie
Avatar

Joined: November/06/2004
Location: Brazil
Online Status: Offline
Info: 27
Added: 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 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 - 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