quote:

---

Microsoft JET Database Engine error '80040e14' Syntax error (comma) in query expression 'FORUM_TOPICS.TOPIC_ID = 17, FORUM_TOPICS.T_INPLACE = 1'.

/forum/pop_open.asp, line 65

---

Here's the relevant code in pop_open.asp, around line 65:

quote:

---

strSql = strSql & " WHERE " & strTablePrefix & "TOPICS.TOPIC_ID = " & Request.Form("TOPIC_ID")

'#################### Lock in place code #################################
if Request.Form("InPlace") = "1" then
strSQL = strSql & ", " & strTablePrefix & "TOPICS.T_INPLACE = 1"
else
strSQL = strSql & ", " & strTablePrefix & "TOPICS.T_INPLACE = 0"
end if
'#################### Lock in place code #################################


my_Conn.Execute (strSql)

%>
<p align=center><font face="<% =strDefaultFontFace %>" size="<% =strHeaderFontSize %>"><b>Topic Un-Locked!</b></font></p>
<% else %>

---

Any ideas? (Please have mercy, I'm a complete ASP novice. )

'#################### Lock in place code #################################
	if Request.Form("InPlace") = "1" then
		strSQL = strSql & ", " & strTablePrefix & "TOPICS.T_INPLACE = 1"
	else
		strSQL = strSql & ", " & strTablePrefix & "TOPICS.T_INPLACE = 0"
	end if
'#################### Lock in place code #################################

strSql = strSql & " WHERE " & strTablePrefix & "TOPICS.TOPIC_ID = " & Request.Form("TOPIC_ID") 

my_Conn.Execute (strSql)

quote:

---

Thanks! That works fine now.

---