Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 7 of 7
Search took 0.00 seconds.
Search: Posts Made By: happygv
Forum: Classic ASP Basics June 10th, 2004, 08:34 PM
Replies: 43
Views: 4,124
Posted By happygv
Yes Morpheus, You already would have a...

Yes Morpheus,

You already would have a connection object initialized. So you got to just add this EXECUTE thing next to your SQL2 statement to get those rows updated with mailsent=1

SQL2=...
Forum: Classic ASP Basics June 5th, 2004, 03:50 AM
Replies: 43
Views: 4,124
Posted By happygv
Hi Dave, That option is ruled out in...

Hi Dave,

That option is ruled out in Morpheus's case, as he is sending personalised content for every recipient. Please read my 3rd previous post to this. Also read Morpheus's original post,...
Forum: Classic ASP Basics June 4th, 2004, 11:18 AM
Replies: 43
Views: 4,124
Posted By happygv
Select top 50 from ORNewsletter where mailsent=0 ...

Select top 50 from ORNewsletter where mailsent=0

IF RS.EOF THEN
Update Table set MailSent=0 'will be done all at one short.
'At this point all records will have Mailsent=1 as you would have...
Forum: Classic ASP Basics June 4th, 2004, 11:00 AM
Replies: 43
Views: 4,124
Posted By happygv
No Imar, there nothing crap in it, except the...

No Imar, there nothing crap in it, except the personalised content, your solution could be must faster really.

Just after reading your reply I did notice that.;)

Morpheus, should be waiting for...
Forum: Classic ASP Basics June 4th, 2004, 10:49 AM
Replies: 43
Views: 4,124
Posted By happygv
Yes you are right Imar. If there is not...

Yes you are right Imar.

If there is not content-wise change in the Newletter this can all done as you said. It should be faster, is what I too feel. But I assume that morpheus does something in...
Forum: Classic ASP Basics June 4th, 2004, 09:44 AM
Replies: 43
Views: 4,124
Posted By happygv
I was also expecting Imar's feedback on this, Or...

I was also expecting Imar's feedback on this, Or if he has a better solution to this. ;)

_________________________
-Vijay G
[8]Strive for Perfection[8]
Forum: Classic ASP Basics June 4th, 2004, 09:17 AM
Replies: 43
Views: 4,124
Posted By happygv
"In batches of 50" how long can it wait before...

"In batches of 50" how long can it wait before sending newsletters for the next 50?

Lets pool in some ideas on it before going for actually coding it.

I would say, you can have an additional...
Showing results 1 to 7 of 7

 


All times are GMT -4. The time now is 11:40 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.