1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81
| <!--#INCLUDE file="connexion.inc" -->
<%
Const adOpenForwardOnly = 0
Const adOpenKeyset = 1
Const adOpenDynamic = 2
Const adOpenStatic = 3
Const adLockReadOnly = 1
Const adLockPessimistic = 2
Const adLockOptimistic = 3
Const adLockBatchOptimistic = 4
Set Rs_addemail = Server.CreateObject("ADODB.Recordset")
Rs_addemail.ActiveConnection = my_conn
Rs_addemail.CursorType = adOpenKeyset
Rs_addemail.LockType = adLockPessimistic
Rs_addemail.CursorLocation = 2
Rs_addemail.Source = "Newsletter"
Rs_addemail.Open
sql = "SELECT distinct(EMAIL) from PNR_TABLE"
set res=my_conn.execute(sql)
res.MoveFirst
while not res.eof and not res.bof
var1=res(0)
var2=0
sql1="select email,section from Newsletter "
sql1=sql1 & "where Newsletter.email='"&var1&"' and Newsletter.section='"&var2&"' "
set res_sql1=my_conn.execute(sql1)
if res_sql1.eof then
'sql12=" insert into Newsletter values( ,'"&var1&"','"&var2&"', )"
'set res_sql12=my_conn.execute(sql12)
Rs_addemail.AddNew
Rs_addemail("email") =var1
Rs_addemail("section") =var2
Rs_addemail.Update
end if
res.movenext
wend
sql2 = "SELECT distinct(EMAIL) from PNR_TABLE where CREDIT_CARD IS NOT NULL"
set res2=my_conn.execute(sql2)
res2.MoveFirst
while not res2.eof and not res2.bof
var11=res2(0)
var22=1
sql22="select email,section from Newsletter"
sql22=sql22 & "where email='"&var11&"' and section='"&var22&"' "
set res_sql22=my_conn.execute(sql22)
if res_sql22.eof then
'sql12=" insert into Newsletter values( ,'"&var1&"','"&var2&"', )"
'set res_sql12=my_conn.execute(sql12)
Rs_addemail.AddNew
Rs_addemail("email") =var11
Rs_addemail("section") =var22
Rs_addemail.Update
end if
res2.movenext
wend
sql3 = "SELECT distinct(EMAIL) from PNR_TABLE where CREDIT_CARD IS NULL"
set res3=my_conn.execute(sql3)
res3.MoveFirst
while not res3.eof and not res3.bof
var111=res3(0)
var222=2
sql33="select email,section from Newsletter"
sql33=sql33 & "where email='"&var111&"' and section='"&var222&"' "
set res_sql33=my_conn.execute(sql33)
if res_sql33.eof then
'sql12=" insert into Newsletter values( ,'"&var1&"','"&var2&"', )"
'set res_sql12=my_conn.execute(sql12)
Rs_addemail.AddNew
Rs_addemail("email") =var111
Rs_addemail("section") =var222
Rs_addemail.Update
end if
res3.movenext
wend
Rs_addemail.Close
Set Rs_addemail = Nothing |
Partager