I'm using the following code to send a welcome letter to a user after they've registered with their username/password. Everything seems to work, but when I test the registration with my squirrelmail accounts and comcast account, I don't receive the email, Gmail & some other accounts work fine.
Any help would be greatly appreciated.
Thanks in advance.
Lee -
<%
-
errorMsg=""
-
submit1=trim(request.form("submit1"))
-
if submit1="hitbutton" then
-
firstName=trim(request.form("sab_firstName"))
-
lastName=trim(request.form("sab_lastName"))
-
sbdc=trim(request.form("sab_sbdc"))
-
consultantName=trim(request.form("sab_consultantName"))
-
consultantEmail=trim(request.form("sab_consultantEmail"))
-
address1=trim(request.form("sab_address1"))
-
address2=trim(request.form("sab_address2"))
-
city=trim(request.form("sab_city"))
-
sab_state=trim(request.form("sab_state"))
-
zip=trim(request.form("sab_zip"))
-
areaCode=trim(request.form("sab_areacode"))
-
phone1=trim(request.form("sab_phone1"))
-
phone2=trim(request.form("sab_phone2"))
-
sab_emailAddr=trim(request.form("sab_emailAddr"))
-
password=trim(request.form("sab_password"))
-
-
'first check if email is unique
-
theSQL="select count(emailAddr) as thecount from SAB_User where ltrim(rtrim(upper(emailAddr)))='"+replace(ucase(sab_emailAddr),"'","''")+"'"
-
set rs=myconn.execute(theSQL)
-
if rs.fields("thecount") > 0 then
-
errorMsg="There is already a user created with this email address. Please login.<br />"
-
else
-
'insert data into table
-
theSQL="insert into SAB_User (firstName,lastName,sbdc,consultantName,consultantEmail,address1,address2,city,sab_state,zip,areacode,phone1,phone2,emailAddr,password,entrydate,editdate) "
-
theSQL=theSQL + "values ('"+replace(firstName,"'","''")+"','"+replace(lastName,"'","''")+"',"+sbdc+",'"+replace(consultantName,"'","''")+"','"+replace(consultantEmail,"'","''")+"','"+replace(address1,"'","''")+"','"+replace(address2,"'","''")+"','"+replace(city,"'","''")+"','"+sab_state+"','"+zip+"','"+areacode+"','"+phone1+"','"+phone2+"','"+replace(sab_emailAddr,"'","''")+"','"+replace(password,"'","''")+"',getdate(),getdate())"
-
-
'response.write(theSQL)
-
myConn.execute(theSQL)
-
session("sab_userID")=""
-
theSQL="select * from sab_user where emailAddr='" + replace(sab_emailAddr,"'","''") + "'"
-
set rs=myConn.execute(theSQL)
-
session("sab_userID")=rs.fields("userID")
-
-
sql="insert into sab_course (userID,sec1_pg,startdate) values ("+trim(rs.fields("userID"))+",1,getdate())"
-
myConn.execute(sql)
-
-
'Welcome Email
-
set myMail=createobject("cdo.message")
-
myMail.subject="Welcome to Starting a Business Tutorial"
-
myMail.from="lee@primerinc.com"
-
myMail.To=rs.fields("firstName") + " " + rs.fields("lastName") + " " + "<"+ sab_emailAddr +">"
-
myMail.textBody="Your User Id: " + sab_emailAddr + chr(13) + chr(10) + "Your password is: " + password
-
myMail.send
-
set myMail=nothing
-
set rs=nothing
-
-
response.Redirect("sec1_intro.asp")
-
-
end if
-
-
end if
-
-
%>
-
0 1211 Sign in to post your reply or Sign up for a free account.
Similar topics
by: Andrew Montgomery |
last post by:
If anybody has experienced the following SquirrelMail error:
Warning: fsockopen(): unable to connect to xx.xx.xx.xx:143 in
/home/virtual/siteX/fst/var/www/squirrelmail/functions/imap_general.php...
|
by: Fokke Nauta |
last post by:
Hi all,
I try to set up an email web-server with an IMAP interface. For the web
interface I use Squirrelmail. PHP is installed. The web server is Xitami.
PHP runs well, but Squirrelmail doesn't....
|
by: Stefan Richter |
last post by:
Hi, after coding for days on stupid form validations -
Like:
strings (min / max length), numbers(min / max value), money(min / max
value), postcodes(min / max value), telefon numbers,
email...
|
by: Benny |
last post by:
Dear All,
I need to send a set of Emails from my application (reminders) each month
1st. Is there anyway in ASP scripts to trigger an event to run
automatically? I have no dedicated server, so...
|
by: kimberly.shaffer |
last post by:
Okay, I can automate sending of multiple emails with records using
Groupwise and Access DB. But now what I need to do is send multiple
fields associated with one field out automatically and can't...
|
by: tshad |
last post by:
I am trying to figure out the best way to send automated emails?
I have emails that I want to send out to certain clients that need them
either daily or weekly.
How would I do in asp.net?
...
|
by: Gene Ariani |
last post by:
I have been asked to create an application to automatically send emails when
a date is reached. These dates are in a table in a database.
How would I approach this since I have never done...
|
by: |
last post by:
Thanks for your help.
I wish I could do that; however our IT department is ... Zelis ... About
security; it's a school district, so lots of confidential data, etc, etc
(their reason).
Oh well,...
|
by: lekshmi200 |
last post by:
I want to send automated emails. I want to send emails to some persons in the table at the end of the day like 10.00 pm every day. How do I do that?
I am using python and mysql.pliseeeeeee give me a...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |