| Author |
 Topic  |
|
|
arizkatt
Starting Member
USA
9 Posts |
 Posted - 18 May 2002 : 21:11:29
|
Hello,
I installed the MSN Messenger MOD today and everything seemed to be fine until I tried to go to members then I got the following error:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'FORUM_MEMBERS.M_DATE FORUM_MEMBERS.M_MSN'.
/forum/members.asp, line 249
I have looked at the code and everything looks ok to me but I don't know ASP very well so I could have missed something. I think I found the are on the code it is talking about and this is what that area of my members.asp looks like:
'## Forum_SQL - Get all members
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " &_
strMemberTablePrefix & "MEMBERS.M_STATUS, " &_
strMemberTablePrefix & "MEMBERS.M_NAME, " &_
strMemberTablePrefix & "MEMBERS.M_LEVEL, " &_
strMemberTablePrefix & "MEMBERS.M_EMAIL, " &_
strMemberTablePrefix & "MEMBERS.M_COUNTRY, " &_
strMemberTablePrefix & "MEMBERS.M_HOMEPAGE, " &_
strMemberTablePrefix & "MEMBERS.M_ICQ, " &_
strMemberTablePrefix & "MEMBERS.M_YAHOO, " &_
strMemberTablePrefix & "MEMBERS.M_AIM, " &_
strMemberTablePrefix & "MEMBERS.M_TITLE, " &_
strMemberTablePrefix & "MEMBERS.M_POSTS, " &_
strMemberTablePrefix & "MEMBERS.M_LASTPOSTDATE, " &_
strMemberTablePrefix & "MEMBERS.M_LASTHEREDATE, " &_
strMemberTablePrefix & "MEMBERS.M_DATE " &_
strMemberTablePrefix & "MEMBERS.M_MSN " &_
" FROM " & strMemberTablePrefix & "MEMBERS "
' #### MSN MOD Added the line ABOVE with MEMBERS.M_MSN #####
if mlev = 4 then
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_NAME <> 'n/a' "
else
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_STATUS = " & 1
end if
Can someone please help me fix this????
Thanks,
Athena
|
|
|
DutchDevil74
Starting Member
1 Posts |
Posted - 19 May 2002 : 06:42:40
|
Hi, from what i see here you'll need to add a comma behind MEMBERS.M_DATE
quote:
'## Forum_SQL - Get all members
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " &_
strMemberTablePrefix & "MEMBERS.M_STATUS, " &_
strMemberTablePrefix & "MEMBERS.M_NAME, " &_
strMemberTablePrefix & "MEMBERS.M_LEVEL, " &_
strMemberTablePrefix & "MEMBERS.M_EMAIL, " &_
strMemberTablePrefix & "MEMBERS.M_COUNTRY, " &_
strMemberTablePrefix & "MEMBERS.M_HOMEPAGE, " &_
strMemberTablePrefix & "MEMBERS.M_ICQ, " &_
strMemberTablePrefix & "MEMBERS.M_YAHOO, " &_
strMemberTablePrefix & "MEMBERS.M_AIM, " &_
strMemberTablePrefix & "MEMBERS.M_TITLE, " &_
strMemberTablePrefix & "MEMBERS.M_POSTS, " &_
strMemberTablePrefix & "MEMBERS.M_LASTPOSTDATE, " &_
strMemberTablePrefix & "MEMBERS.M_LASTHEREDATE, " &_
strMemberTablePrefix & "MEMBERS.M_DATE " &_
strMemberTablePrefix & "MEMBERS.M_MSN " &_
" FROM " & strMemberTablePrefix & "MEMBERS "
' #### MSN MOD Added the line ABOVE with MEMBERS.M_MSN #####
if mlev = 4 then
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_NAME <> 'n/a' "
else
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_STATUS = " & 1
end if
... this should solve it:
strMemberTablePrefix & "MEMBERS.M_DATE, " &_
strMemberTablePrefix & "MEMBERS.M_MSN " &_
" FROM " & strMemberTablePrefix & "MEMBERS "
|
 |
|
|
arizkatt
Starting Member
USA
9 Posts |
Posted - 20 May 2002 : 14:49:31
|
Thank you so much; it fixed it.
Granted I now feel VERY silly for not noticing that it was just commas that were missing.
Thanks again!!!
|
|
|
| |
Topic |
|
|
|
Topic Locked
