Microsoft JET Database Engine error '80040e14' 

Syntax error in ORDER BY clause. 

/admin_usergroups.asp, line 117 

quote:

---

Originally posted by altisdesign

Nikkol,

Do you know if that LIMIT 0,1 is compatible with access? I havnt tested it, I only used it on myswl and its working fine with that code.. my users love it . It could be removed all together, I only put it in to improve performance, as only the first id is needed. I suppose we could test the strdbtype and use SELECT TOP 1 if its access.

---

Microsoft JET Database Engine error '80040e10' 
No value given for one or more required parameters. 

/post.asp, line 1489

if strRqMethod = "EditForum" or strRqMethod = "EditURL" then
			strSql = "SELECT MEMBER_ID "
			strSql = strSql & " FROM " & strTablePrefix & "ALLOWED_MEMBERS "
			strSql = strSql & " WHERE FORUM_ID = " & strRqForumID
			strSql = strSql & " ORDER BY M_NAME "

			set rsAllowedMember = Server.CreateObject("ADODB.Recordset")
			rsAllowedMember.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText

			if rsAllowedMember.EOF then
				recAllowedMemberCount = ""
			else
				allAllowedMemberData = rsAllowedMember.GetRows(adGetRowsRest)
				recAllowedMemberCount = UBound(allAllowedMemberData,2)
				amMEMBER_ID = 0
			end if

quote:

---

Originally posted by altisdesign

OK I will make a change using strdbtype to determine whether to use LIMIT or TOP. Which is the prefered method of limiting records on SQL Server?

---

quote:

---

Originally posted by Klingstedt

I have set deny as a permission for my only membergroup (which new user autojoin), but guests can see the whole forum. And if they click on the "New Topic"-link they can post a new topic in the forum. They can fill in a userīs usernamne and password (in my only membergroup) and post a new topic in that members name. That member donīt even have access to that forum.

---

quote:

---

Originally posted by altisdesign

quote:

---

Originally posted by Klingstedt

I have set deny as a permission for my only membergroup (which new user autojoin), but guests can see the whole forum. And if they click on the "New Topic"-link they can post a new topic in the forum. They can fill in a userīs usernamne and password (in my only membergroup) and post a new topic in that members name. That member donīt even have access to that forum.

---

Is the forum set to Allowed Member List / Allowed Member List (Hidden). Then you set explicit allow permissions for the members who are allowed in. The usergroups mod does not handle users who are not signed up AFAIK, you would need to set the Auth Type for that forum.

---