Ok. I have kind of been looking into this a little bit. I am trying to implement an add-on to the "Email All Users Mod". I have added selections to this mod before so I know how to do it, but this one is throwing a wrench in the works for me. Here is where I have gotten so far.
In the table "FORUM_MEMBERS" the field "M_DOB" looks like it is stored as a string in the form of "yyyymmdd". To admin_pop_mail.asp ("Email All Users") I have added the following to my SQL statement:
if Err_Msg = "" then
'FORMAT TODAYS DATE TO MATCH THE DATABASE STRING (M_DOB)
Dim today
today = Left(DateToStr(strForumTimeAdjust),8)
'END DATE FUNCTION
strSql = "SELECT M_NAME, M_EMAIL, M_LEVEL, M_DOB"
......
Case 4
strSql = strSql & " AND M_DOB = " & today
I added a response.write strSql above the :
rsMail.Open strSql, my_Conn, 0, 1, &H0001
, to ensure it was converting the date correctly to a string and in the same format as it is stored in DB (Access). However, when I try to send an email to the "Case 4" Members (test), I get this error:
SELECT M_NAME, M_EMAIL, M_LEVEL, M_DOB
FROM FORUM_MEMBERS WHERE M_STATUS = 1
AND M_RECEIVE_EMAIL = 1 AND M_DOB = 20060731
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forum/forum2/admin_pop_mail.asp, line 157
Any ideas here? The SQL looks good and the output of the Response.Write looks good too? What else could it be really? Knowing me, something small and stupid that I overlooked again. LOL.
<
Birthday MOD - Automatically send email on B-Day?
Posted - 30 July 2006 : 07:40:04
<
