send email notification

Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/65764?pagenum=1
05 November 2025, 03:12

Topic


s80ts0465
send email notification
18 October 2007, 04:44


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:
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<

 

Replies ...


s80ts0465
18 October 2007, 04:56


Ok sorry to bug you, i've already solved the stupid problem!!<
© 2000-2021 Snitz™ Communications