Welcome to the dBforums forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

If you prefer not to see double-underlined words and corresponding ads, place your cursor
here for ContentLink opt out.

Go Back  dBforums > Data Access, Manipulation & Batch Languages > ASP > sending emails in ASP

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-02-03, 11:46
farzinm farzinm is offline
Registered User
 
Join Date: Feb 2003
Location: USA
Posts: 18
sending emails in ASP

I have some 20000 users whom I need to send emails using ASP. My script worked fine until the number of users increased to such a large amount, so I believe its a Scripttimeout/Session Timeout problem that I am facing since my script stops running with a "Page cannot be displayed". We couldnt get to see the error because the "show friendly messages" on the browser was on.
I want to know how will it affect my server if I increase the timeout values from
Session.Timeout = 170
Server.ScriptTimeout = 10000
to
Session.Timeout = 370 'approx 6.16 hrs
Server.ScriptTimeout = 20000 'approx 5.5 hrs

Any suggestions pointing to good urls and a solution to this problem will be appreciated.
Thanks
Reply With Quote
  #2 (permalink)  
Old 04-02-03, 14:21
Memnoch1207 Memnoch1207 is offline
Registered User
 
Join Date: Jan 2003
Location: Midwest
Posts: 138
here is what I use to do mass mailings for clients

Server.ScriptTimeout = 3600
db_open(Application("ConnectionString"))
set email = db_query("SELECT * FROM emails")
Set textStreamObject = fs.OpenTextFile(Application("BasePath") & "templates\email.html",1,false,0)
strBody = textStreamObject.ReadAll
Set filetxt = fs.CreateTextFile(Application("BasePath") & "templates\emails_sent.txt",true,false)
do until email.eof
SendMailHTML email("email"), Application("OwnerEmail"), "Subject", strBody
filetxt.WriteLine(email("email"))
email.movenext
loop
filetxt.close
db_close
Reply With Quote
  #3 (permalink)  
Old 04-02-03, 14:50
farzinm farzinm is offline
Registered User
 
Join Date: Feb 2003
Location: USA
Posts: 18
Question

THanks for replying
It gives me an error

Microsoft VBScript runtime error '800a000d'
Type mismatch: 'SendMailHTML'

Any clues?
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On