Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Need Help Fixing This CODE.		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Fuzion
Junior Member

162 Posts
Posted - 21 July 2002 :  16:16:54  Show Profile
--------------------------------------------------------------------------------
Im getting this error..

Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression 'FORUM_MEMBERS.MEMBER_ID ='.

/content/include/inc_mainmenu.asp, line 12

And I think It may be because of this line of code, i just dont know how to fix it.


<%

'########## Portal Options ########## - Start

If strUserMemberID = -1 then
'do nothing
else
strSql = "Select " & strMemberTablePrefix & "MEMBERS.M_CONTENT"
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS"
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " & strUserMemberID

set rs0 = my_Conn.Execute (strSql)
content = rs0("M_CONTENT")
rs0.close
set rs0 = nothing

if content = "" or content = " " or isnull(content) then
content = "empty"
end if
end if

'########## Portal Options ########## - End
%>





NeilQuest Hosting Service:
http://www.NeilQuest.com

Site Designs For Sale:
http://www.NeilQuest.com/designstore.asp

Just giving my two cents worth.

HuwR
Forum Admin

United Kingdom
20600 Posts
Posted - 21 July 2002 :  16:31:00  Show Profile  Visit HuwR's Homepage
you are getting the error because strUserMemberID must be empty
Go to Top of Page

Fuzion
Junior Member

162 Posts
Posted - 21 July 2002 :  16:36:28  Show Profile
*scratches head* Im not really good at coding, but how do i make it empty, or change the value so it doesnt have to be empty.

NeilQuest Hosting Service:
http://www.NeilQuest.com

Site Designs For Sale:
http://www.NeilQuest.com/designstore.asp

Just giving my two cents worth.
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts
Posted - 21 July 2002 :  16:41:56  Show Profile
YOu don't need to make it empty, HuwR meant that when it IS empty the SQL will fail. Something to add to your code would be to check that strUserMemberID <> "" before you execute the code, just like you're doing to content afterwards.
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 21 July 2002 :  17:34:58  Show Profile
You might want to do something like:
If strUserMemberID = -1 or strUserMemberID = "" then
'do nothing
else
strSql = "Select " & strMemberTablePrefix & "MEMBERS.M_CONTENT"
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS"
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.MEMBER_ID = " &
strUserMemberID



«------------------------------------------------------»
What new features are going to be in the 3.4
version? See the 3.4 UnOfficial Features List !
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.31 seconds. Powered By: Snitz Forums 2000 Version 3.4.07