| Author |
 Topic  |
|
|
Jeepers Ron
New Member
USA
95 Posts |
 Posted - 10 May 2002 : 14:12:45
|
My private messages are working but. When any of my members go into the Preferences and Changes the Enable/Disable Private Messages to either Enable or Disable,
This error code pops up.
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/forum/pm_options.asp, line 58
Any ideas?
|
|
|
Jeepers Ron
New Member
USA
95 Posts |
Posted - 11 May 2002 : 07:17:46
|
Funny thing about this error is:
It works if I change this setting logged in as the administrator, but does not work when logged in as a regular member, giving me that error code.
Also, how do I find line 58 using note pad as my editer?
Edited by - Jeepers Ron on 11 May 2002 07:23:57 |
 |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 11 May 2002 : 07:20:52
|
by counting. use an editor such as InterDev for line numbers.
Crash's Site | Crash is from 
|
|
|
|
Jeepers Ron
New Member
USA
95 Posts |
Posted - 11 May 2002 : 07:35:30
|
I take it, that's not a free download?
|
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 11 May 2002 : 07:38:13
|
unfortunately, no. but you could try a search on this site for "editor"...
Crash's Site | Crash is from
|
|
|
|
Jeepers Ron
New Member
USA
95 Posts |
Posted - 11 May 2002 : 08:13:01
|
Here is lines 50 through 70. I don't see what's wrong, but then again I don't know what I'm looking for.
if Request.QueryString("mode") = "setoptions" then
'## Forum_SQL
strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " SET M_PMRECEIVE = '" & Request.Form("statusstorage") & "', "
strSql = strSql & " M_PMEMAIL = '" & Request.Form("emailstorage") & "'"
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_NAME = '" & strDBNTUserName & "'"
strSql = strSql & " AND " & strMemberTablePrefix & "MEMBERS.M_PASSWORD = '" & Request.Cookies(strUniqueID & "User")("PWord") & "'"
This is line 58-> my_Conn.Execute(strSql)
if strSetCookieToForum = 1 then
Response.Cookies(strCookieURL & "paging").Path = strCookieURL
end if
Response.Cookies(strCookieURL & "paging")("outbox") = Request.Form("layoutstorage")
Response.Cookies(strCookieURL & "paging").Expires = dateAdd("d", 360, strForumTimeAdjust)
Response.Write "<meta http-equiv=""Refresh"" content=""2; URL=pm_view.asp"">" & vbNewLine & _
"<center>" & vbNewLine & _
"<br><br><br>" & vbNewLine & _
"<font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><b>Success</b></font>" & vbNewLine & _
"<br>" & vbNewLine & _
"<font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><a href=""pm_view.asp""><b>Return to your inbox</b></a></font>" & vbNewLine & _
Edited by - Jeepers Ron on 11 May 2002 08:16:11 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 11 May 2002 : 12:48:17
|
I use this editor: http://www.araneae.com
try changing the following 2 lines of code from this:
strSql = strSql & " SET M_PMRECEIVE = '" & Request.Form("statusstorage") & "', "
strSql = strSql & " M_PMEMAIL = '" & Request.Form("emailstorage") & "'"
to this:
strSql = strSql & " SET M_PMRECEIVE = " & Request.Form("statusstorage")
strSql = strSql & ", M_PMEMAIL = " & Request.Form("emailstorage") |
|
|
|
Jeepers Ron
New Member
USA
95 Posts |
Posted - 11 May 2002 : 19:14:46
|
Okay, I tried that. now I get this error message
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression ''1 M_PMEMAIL = '1'.
/forum/pm_options.asp, line 58
|
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 11 May 2002 : 19:19:41
|
quote:
Syntax error (missing operator) in query expression ''1 M_PMEMAIL = '1'.
you think that's odd? what is the red number doing there?
try to be more carefull when you copy/paste some code...
Crash's Site | Crash is from
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 11 May 2002 : 19:31:03
|
| you are missing the comma, make sure you copy the lines of code exactly like I have them above. |
|
|
|
Jeepers Ron
New Member
USA
95 Posts |
Posted - 11 May 2002 : 21:05:23
|
okay, I made that change but I'm still having problems. I've signed in as a new user many times and this is what happens:
First I go into Private Messages then to Preferences
The strange thing I found out is; Their are three options you can change the first 2 don't have anything picked, but the 3rd one has something picked. If I just pick one option and leave one without click on it (the little green dot in the O)
Then I'll get a error code.
This was the lastest:
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/forum/pm_options.asp, line 58
But, If I check them all before pressing Submit Then I don't get any error code and if works from then on.
BUT
There is still another problem.
If I change InBox/OutBox Preferences to 2 page layout then log into my other ID where I had this option set to single page layout would end up 2 page layout This change is effecting all members.
Any ideas?
Edited by - Jeepers Ron on 11 May 2002 21:07:26 |
|
|
| |
Topic |
|
Topic Locked
