When I try to access the Moderator Setup in the admin panel I get the following error:
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) /bbs/bbs/newbbs/Snitz_Forums_2000_V3_1_SR4/inc_functions.asp, line 1089 Please tell me why. Please help
I only know the following information: Eorro type£º Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) /bbs/bbs/newbbs/Snitz_Forums_2000_V3_1_SR4/inc_functions.asp, µÚ 1089 ÐÐ
Browser type£º Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Page£º GET /bbs/bbs/newbbs/Snitz_Forums_2000_V3_1_SR4/admin_moderators.asp
quote: When I try to access the Moderator Setup in the admin panel I get the following error:
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) /bbs/bbs/newbbs/Snitz_Forums_2000_V3_1_SR4/inc_functions.asp, line 1089 Please tell me why. Please help
I get a similar error - here:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'FORUM_MODERATOR.MEMBER_ID = web@stuff.com.au AND FORUM_MODERATOR.FORUM_ID = 7'.
/forums/admin_moderators.asp, line 121
This is what happens when I insert a Response.Write as opposed to the "my_Conn.Execute" :
SELECT FORUM_MODERATOR.FORUM_ID, FORUM_MODERATOR.MEMBER_ID, FORUM_MODERATOR.MOD_TYPE FROM FORUM_MODERATOR WHERE FORUM_MODERATOR.MEMBER_ID = web@stuff.com.au AND FORUM_MODERATOR.FORUM_ID = 7