Ok, the base of my code is Ocean12 ASP Mailing List Manager. The free version of the script has it's limitations, so I'm attempting add a feature here & there on my own.
As it stands, when you sign up for the Newsletter, it adds your e-mail to the database and that's it. The next step is I send a mailing to the list and get bounced e-mails for the people that say their e-mail address has a coma in it or that don't give me the "@yahoo.com" portion of their address.
Rather than get 5-10 bounced e-mails at once, I'd rather 'weed them out' as I go. And provide a security feature into the script. The database table looks like this at Download:
ID | EMail | First Name | Last Name | Date Joined
I've added a sixth column to the table, "Conf" which is a Yes/No field. Either it's "true" or it's "false". I should mentioned, I'm running off of Access. By default, when a user signs up, the Conf field is set to 'False'. For all intents and purposes, this means they haven't "Confirmed" their subscription yet.
At this point, and e-mail is sent to the directing them to a particular URL which will 'confirm' their subscription. I've skipped the automated e-mail for now, because I'm working on the page it directs them to first.
This is where my problem comes in. To keep the the confirmation process somewhat secure, I'm directing them to "confirm.asp?Emailemail@example.com" for instance, without the () of course.
However, it's returning Syntax error (missing operator) in query expression 'Email = firstname.lastname@example.org'. The code I'm using follows:
Any help is much appreciated! :-)
Try this instead:
strSql = "SELECT * FROM List WHERE Email = '" & Email & "' "
*speaking in a very monotone voice while glancing occassionally at the palm of my hand to read a small piece of paper...*
Seriously, m8, thanks a bunch! :-)
That did the trick! :-)
Dang, I have to give better prompts! ;)
|All times are GMT +1. The time now is 03:40 PM.|
Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.