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 20 of 20
Search took 0.00 seconds.
Search: Posts Made By: morpheus
Forum: Classic ASP Basics June 11th, 2004, 12:40 PM
Replies: 43
Views: 4,107
Posted By morpheus
Thanks a lot Imar, I have checked out the...

Thanks a lot Imar, I have checked out the Global.asa and it's all there. I actually am just keeping a few websites up-to-date and adding what's needed. It looks like they were designed using...
Forum: Classic ASP Basics June 11th, 2004, 11:34 AM
Replies: 43
Views: 4,107
Posted By morpheus
Here's the thing that I don't understand, whoever...

Here's the thing that I don't understand, whoever set up the website before me does not use the connection string like you guys us it, like the one above. All I see everywhere through the code are...
Forum: Classic ASP Basics June 11th, 2004, 11:11 AM
Replies: 43
Views: 4,107
Posted By morpheus
Thanks Imar, I understand exactly what you are...

Thanks Imar, I understand exactly what you are saying and I apperciate the time you take to help me :). I guess I just thought I understood it better than I did. I think I can handle the SQL side...
Forum: Classic ASP Basics June 11th, 2004, 09:41 AM
Replies: 43
Views: 4,107
Posted By morpheus
Here is the example I got from the MSDN library ...

Here is the example I got from the MSDN library

Dim oConn As ADODB.Connection
Dim oRs As ADODB.Recordset
Dim sConn As String
Dim sSQL as String

sConn = "Provider='SQLOLEDB';Data...
Forum: Classic ASP Basics June 11th, 2004, 07:33 AM
Replies: 43
Views: 4,107
Posted By morpheus
SQL2= "Update ORNewsletterTest set Mailsent=1...

SQL2= "Update ORNewsletterTest set Mailsent=1 where NewsletterId in (" & NewsletterId & ")"


Dim oConn
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open SQL2, oConn, 1, 2, &H0001...
Forum: Classic ASP Basics June 10th, 2004, 12:09 PM
Replies: 43
Views: 4,107
Posted By morpheus
Dim SQL2 SQL2= "Update ORNewsletterTest set...

Dim SQL2
SQL2= "Update ORNewsletterTest set Mailsent=1 where NewsletterId in (" & NewsletterId & ")"

Response.Write(SQL2)

I have this code after the loop and it seems to hold the proper data...
Forum: Classic ASP Basics June 10th, 2004, 09:26 AM
Replies: 43
Views: 4,107
Posted By morpheus
The array seems to work fine and it only sent it...

The array seems to work fine and it only sent it to the top 5 which I wanted but I checked the DB and the Mailsent are all still set to 0. Won't this statement update the databse? I want to make...
Forum: Classic ASP Basics June 10th, 2004, 09:17 AM
Replies: 43
Views: 4,107
Posted By morpheus
I added the loop like this If...

I added the loop like this

If Len("NewsletterId") > 0 And LoopCounter > 0 Then
NewsletterId = NewsletterId & ", "
End If
NewsletterId = NewsletterId & RS("NewsletterId")

But now it...
Forum: Classic ASP Basics June 10th, 2004, 07:55 AM
Replies: 43
Views: 4,107
Posted By morpheus
well I did now ;) Okay this time I got this ...

well I did now ;)

Okay this time I got this

Update ORNewsletterTest set Mailsent=1 where NewsletterId in (, 1, 2, 3, 4, 5)



-----------------------------------------------------------...
Forum: Classic ASP Basics June 10th, 2004, 07:35 AM
Replies: 43
Views: 4,107
Posted By morpheus
I can't show you the outcome of the sql statment...

I can't show you the outcome of the sql statment because it never makes it there I moved this up into the loop but it still generates an error
I don't think the syntax is right :-(


If...
Forum: Classic ASP Basics June 10th, 2004, 07:12 AM
Replies: 43
Views: 4,107
Posted By morpheus
Here is my new code with your new update statment...

Here is my new code with your new update statment

It stops on this line

error '80020009'
Exception occurred.

NewsletterId = NewsletterId & RS("NewsletterId")
...
Forum: Classic ASP Basics June 9th, 2004, 01:52 PM
Replies: 43
Views: 4,107
Posted By morpheus
It said Exception occurred but the...

It said

Exception occurred

but the email's were still sent to my test address so I am not sure why that is

-----------------------------------------------------------
"Don't follow someone...
Forum: Classic ASP Basics June 9th, 2004, 01:18 PM
Replies: 43
Views: 4,107
Posted By morpheus
Okay Imar I was using your example that you and...

Okay Imar I was using your example that you and vijay helped me with.

SQLStr="SELECT top 50 * FROM ORNewsletterTest"
Set RS=Server.CreateObject("ADODB.Recordset")
RS.Open...
Forum: Classic ASP Basics June 9th, 2004, 01:01 PM
Replies: 43
Views: 4,107
Posted By morpheus
Thanks for the help guys but I am getting stuck...

Thanks for the help guys but I am getting stuck on this one line

NewsletterId = NewsletterId & RS("NewsletterId")

It says Exception occurred for this line and I am not sure why, is this the...
Forum: Classic ASP Basics June 7th, 2004, 07:15 AM
Replies: 43
Views: 4,107
Posted By morpheus
Sorry I didn't get back, I was away all weekend. ...

Sorry I didn't get back, I was away all weekend. Thanks Guys for your help, To Imar, I don't think scheduling a script is an option for us because I don't know when it will go out each day, I guess...
Forum: Classic ASP Basics June 4th, 2004, 02:07 PM
Replies: 43
Views: 4,107
Posted By morpheus
Can this be done? Couldn't I just loop...

Can this be done?

Couldn't I just loop through the entire record sending one email to each record and then just close the record set and have .eof = true and move on to the next page.

Or would...
Forum: Classic ASP Basics June 4th, 2004, 11:53 AM
Replies: 43
Views: 4,107
Posted By morpheus
Okay I set up a test Table with 10 email addy's...

Okay I set up a test Table with 10 email addy's in it. I will try and send it to 5 at a time.

I am not sure how to do this exactly

While not RS.EOF
Send mail one by one.
And store the mailId...
Forum: Classic ASP Basics June 4th, 2004, 11:08 AM
Replies: 43
Views: 4,107
Posted By morpheus
Yes, The newsletter page grabs all of todays news...

Yes, The newsletter page grabs all of todays news and sends links to those articles, but only ones that are posted today, The newsleter is sent out at different times during the day because we...
Forum: Classic ASP Basics June 4th, 2004, 09:27 AM
Replies: 43
Views: 4,107
Posted By morpheus
We send out the Newsletter at the end of...

We send out the Newsletter at the end of everyday, after all the news comes in for that day. So if it send in batch's of 50 it would need to do it right in a row. I wasn't have a problem until this...
Forum: Classic ASP Basics June 4th, 2004, 08:44 AM
Replies: 43
Views: 4,107
Posted By morpheus
ASP Email Newsletter help?

You guys are going to hate me real soon, lol

I have an asp page that sends a Newsletter to all the subsrcibers in the database. But we have been having trouble with it latley and my Hosting ...
Showing results 1 to 20 of 20

 


All times are GMT -4. The time now is 06:30 AM.


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