I've adden a droplist in the post.asp.
Now i want to send an email notification to different mailling list considering the choice in the droplist.
I've modify the post_info.asp using this code:
strSql = "SELECT M_EMAIL FROM " & strMemberTablePrefix & "MEMBERS"
strSql = strSql & " WHERE M_NAME = **********"
Set rs33 = Server.CreateObject("ADODB.Recordset")
rs33.open strSql, my_Conn
email = rs33("M_EMAIL")
rs33.Close
set rs33 = nothing
but it doesn't work and i think that the problem is in the WHERE part!
Can you help me<
send email notification
Posted - 18 October 2007 : 04:44:06
