SMS sender fejl !!!!!
Den sender alle nummrene ud til sonofon abonomenter.En der kan se fejlen ???
<%
Set JMail = Server.CreateObject(\"JMail.SMTPMail\")
JMail.ServerAddress = \"mail.domain.dk\"
JMail.Sender = \"mail@domain.dk\"
strConnect = \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=d:\\home\\domain\\db\\users.mdb\"
Set mvarCon = Server.CreateObject (\"ADODB.Connection\")
mvarCon.Open strConnect
Set mvarCommand = Server.CreateObject(\"ADODB.Command\")
Set mvarCommand.ActiveConnection = mvarCon
Dim RS
Set Cm = Server.CreateObject(\"ADODB.Command\")
Set Rs = Server.CreateObject(\"ADODB.RecordSet\")
Cm.ActiveConnection = mvarCon
if sex = \"A\" AND alder = \"2\" then
strQuery = \"SELECT * FROM tblUsers WHERE aktiv = \'Ja\' AND smsnews = \'Ja\' AND Cpr >= #\" & DateAdd(\"yyyy\",-20,Now) & \"#\"
elseif sex = \"A\" AND alder = \"1\" then
strQuery = \"SELECT * FROM tblUsers WHERE aktiv = \'Ja\' AND smsnews = \'Ja\' AND Cpr < #\" & DateAdd(\"yyyy\",-20,Now) & \"#\"
elseif alder = \"1\" then
strQuery = \"SELECT * FROM tblUsers WHERE aktiv = \'Ja\' AND sex = \'\" & sex & \"\' AND smsnews = \'Ja\' AND Cpr < #\" & DateAdd(\"yyyy\",-20,Now) & \"#\"
elseif alder = \"2\" then
strQuery = \"SELECT * FROM tblUsers WHERE aktiv = \'Ja\' AND sex = \'\" & sex & \"\' AND smsnews = \'Ja\' AND Cpr >= #\" & DateAdd(\"yyyy\",-20,Now) & \"#\"
elseif alder = \"0\" AND sex = \"A\" then
strQuery = \"SELECT * FROM tblUsers WHERE aktiv = \'Ja\' AND smsnews = \'Ja\'\"
elseif alder = \"0\" AND sex = \"K\" OR alder = \"0\" AND sex = \"M\" then
strQuery = \"SELECT * FROM tblUsers WHERE aktiv = \'Ja\' AND smsnews = \'Ja\' AND sex = \'\" & sex & \"\'\"
end if
rs.open strQuery, mvarCon, 3, 3, 1
Antallet = RS.RecordCount
%>
<input type=\"button\" style=\"width:220;\" class=\"text\" value=\"Din besked er afsendt til <%=antallet%> brugere !\"</a><p>
<%
If Not (rs.BOF Or rs.EOF) Then
send = \"true\"
Do While Not rs.EOF
if hvad = \"1\" then
mobil = rs(\"mobiltelefon\")
navn = rs(\"username\")
teledk = \"@sms.tdm.dk\"
sonofon = \"@note.sonofon.dk\"
telia = \"@gsm1800.telia.dk\"
mobilix = \"@sms.mobilix.dk\"
if int(left(mobil,4)) => 2010 AND int(left(mobil,4)) =< 2059 then
selskab = teledk
elseif int(left(mobil,4)) => 2060 AND int(left(mobil,4)) =< 2099 then
selskab = sonofon
elseif int(left(mobil,4)) => 2110 AND int(left(mobil,4)) =< 2199 then
selskab = teledk
elseif int(left(mobil,4)) => 2210 AND int(left(mobil,4)) =< 2299 then
selskab = sonofon
elseif int(left(mobil,4)) => 2310 AND int(left(mobil,4)) =< 2499 then
selskab = teledk
elseif int(left(mobil,4)) => 2610 AND int(left(mobil,4)) =< 2699 then
selskab = mobilix
elseif int(left(mobil,4)) => 2810 AND int(left(mobil,4)) =< 2899 then
selskab = telia
elseif int(left(mobil,4)) => 2910 AND int(left(mobil,4)) =< 2999 then
selskab = teledk
elseif int(left(mobil,4)) => 3010 AND int(left(mobil,4)) =< 3099 then
selskab = teledk
elseif int(left(mobil,4)) => 4010 AND int(left(mobil,4)) =< 4049 then
selskab = teledk
elseif int(left(mobil,4)) => 4050 AND int(left(mobil,4)) =< 4099 then
selskab = sonofon
end if
if selskab = mobilix then
JMail.SenderName = besked
else
Jmail.Body = besked
end if
JMail.Priority = 3
response.write \"\" & mobil & \" - \" & navn & \"<br>\"
Jmail.AddRecipient \"\" & rs(\"mobiltelefon\") & selskab
end if
RS.movenext
loop
else
session(\"fejl\") = \"Der var ingen at sende til !!<br>\"
Response.Redirect \"sms.asp?mode=fejl\"
end if
RS.Close
Set RS = Nothing
mvarCon.Close
Set mvarCon = Nothing
if send = \"true\" then
JMail.Execute
end if
Set JMail = Nothing
elseif mode = \"fejl\" then
%>
