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 16 of 16
Search took 0.00 seconds.
Search: Posts Made By: Imar
Forum: Classic ASP Basics June 11th, 2004, 01:07 PM
Replies: 43
Views: 4,185
Posted By Imar
That sounds like a great idea ;) Visual...

That sounds like a great idea ;)

Visual Interdev creates a zillion lines of code for things that you can do yourself in only three or four lines. It does that to "shield you from complicated stuff...
Forum: Classic ASP Basics June 11th, 2004, 12:29 PM
Replies: 43
Views: 4,185
Posted By Imar
Your connection string is this: ...

Your connection string is this:

Application("DBConn")

Somewhere (probably in the file called global.asa in the root of your site), the connection string is saved to an Application variable...
Forum: Classic ASP Basics June 11th, 2004, 11:01 AM
Replies: 43
Views: 4,185
Posted By Imar
I'll be more than happy to repeat the same stuff...

I'll be more than happy to repeat the same stuff over and over again ;)
You don't need a recordset; all you need is my code with a suitable connection string. Since you're not retrieving records...
Forum: Classic ASP Basics June 11th, 2004, 09:00 AM
Replies: 43
Views: 4,185
Posted By Imar
No, you don't. You can use the exact code I gave...

No, you don't. You can use the exact code I gave you:Dim oConn
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open YourConnectionStringHere
oConn.Execute(SQL2)
oConn.Close
Set oConn =...
Forum: Classic ASP Basics June 10th, 2004, 01:52 PM
Replies: 43
Views: 4,185
Posted By Imar
Ah, that explains a lot. The easiest way to...

Ah, that explains a lot.

The easiest way to do that is to use the Execute (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthcnnexecute.asp) method of the connection...
Forum: Classic ASP Basics June 10th, 2004, 11:51 AM
Replies: 43
Views: 4,185
Posted By Imar
Are you sure you're executing the code? Did you...

Are you sure you're executing the code? Did you take out the Response.End part?

If that doesn't help, can you post the relevant code for the database update? And the output of the Response.Write...
Forum: Classic ASP Basics June 10th, 2004, 08:59 AM
Replies: 43
Views: 4,185
Posted By Imar
Right, that's what I thought. You need a way to...

Right, that's what I thought. You need a way to ignore the first comma. There are at least 2 ways to do that.

1. Strip if of, right before you send it.

NewsletterId = Right(NewsletterId,...
Forum: Classic ASP Basics June 10th, 2004, 07:45 AM
Replies: 43
Views: 4,185
Posted By Imar
Did you move it to before the MoveNext call?

Did you move it to before the MoveNext call?
Forum: Classic ASP Basics June 10th, 2004, 07:21 AM
Replies: 43
Views: 4,185
Posted By Imar
Oh, and another thing: You should move the code...

Oh, and another thing: You should move the code that adds the ID to inside the loop:

RS.MoveNext
next
.....

'And store the mailId or KeyFieldValue in an array

If len(NewsletterId) > 0 Then...
Forum: Classic ASP Basics June 10th, 2004, 07:18 AM
Replies: 43
Views: 4,185
Posted By Imar
What I meant was for you to post the outcome of...

What I meant was for you to post the outcome of your SQL statement. I think it will end up like this:

WHERE Bla bla IN (1, 2, 3, )

As you can see, it ends with an additional comma, which is not...
Forum: Classic ASP Basics June 9th, 2004, 04:38 PM
Replies: 43
Views: 4,185
Posted By Imar
Nothing else? No error number? What happens...

Nothing else? No error number?

What happens when you write out the SQL statement? I assume your code looks different from what you posted last time??

update "ORNewsletterTest set Mailsent=1...
Forum: Classic ASP Basics June 9th, 2004, 01:24 PM
Replies: 43
Views: 4,185
Posted By Imar
What error do you get? Imar

What error do you get?

Imar
Forum: Classic ASP Basics June 9th, 2004, 01:13 PM
Replies: 43
Views: 4,185
Posted By Imar
Can you post some more code? I can't see anything...

Can you post some more code? I can't see anything wrong with this single line. Posting the exact error message may help as well.

Cheers,

Imar
---------------------------------------
Imar...
Forum: Classic ASP Basics June 4th, 2004, 03:25 PM
Replies: 43
Views: 4,185
Posted By Imar
Here's what I would do: 1. SELECT TOP 50...

Here's what I would do:

1. SELECT TOP 50 FROM Bla bla WHERE mailsent=0
(assuming your database supports Top)

2. Loop through the recordset and send out your e-mail. Inside the loop, keep track...
Forum: Classic ASP Basics June 4th, 2004, 10:56 AM
Replies: 43
Views: 4,185
Posted By Imar
You are absolutely right. I completely overlooked...

You are absolutely right. I completely overlooked the personalized part of the message, so the BCC solution can't be used.

See, I told you I was talking crap..... ;)

Cheers,

Imar...
Forum: Classic ASP Basics June 4th, 2004, 10:30 AM
Replies: 43
Views: 4,185
Posted By Imar
I am not sure how mail servers handle this...

I am not sure how mail servers handle this internally, but you could send the e-mail To yourself, and then BCC 50 addresses in each message. This way, your ASP application sets up a connection with...
Showing results 1 to 16 of 16

 


All times are GMT -4. The time now is 11:59 PM.


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