quote:

---

Microsoft OLE DB Provider for ODBC Drivers error '80040e09'

[TCX][MyODBC]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT Count(M_TO) FROM FORUM_MEMBERS M, FORUM_PM P WHERE M.M_N

/privateread.asp, line 119

---

quote:

---

if strDBType = "access" then ' Get Private Message Total for Display(Access)
strSqL = "SELECT count(M_TO) as [pmtotal1] FROM " & strMemberTablePrefix & "MEMBERS M, " & strTablePrefix & "PM P WHERE M.M_NAME = '" & strDBNTUserName & "' AND M.MEMBER_ID = P.M_TO "
Set rsPM1 = my_Conn.Execute(strSql)

strSqL = "SELECT count(M_FROM) as [pmtotal2] FROM " & strMemberTablePrefix & "MEMBERS M, " & strTablePrefix & "PM P WHERE M.M_NAME = '" & strDBNTUserName & "' AND M.MEMBER_ID = P.M_FROM "
Set rsPM2 = my_Conn.Execute(strSql)

pmtotal1 = rsPM1("pmtotal1")
pmtotal2 = rsPM2("pmtotal2")

rsPM1.close
set rsPM1 = nothing
rsPM2.close
set rsPM2 = nothing


else
' Get Private Message Total for display(SQL, mySQL)
strSql = "SELECT pmtotal1=(SELECT Count(M_TO) FROM " & strMemberTablePrefix & "MEMBERS M, " & strTablePrefix & "PM P WHERE M.M_NAME = '" & strDBNTUserName & "' AND M.MEMBER_ID = P.M_TO), pmtotal2=(SELECT Count(M_FROM) FROM " & strMemberTablePrefix & "MEMBERS M, " & strTablePrefix & "PM P WHERE M.M_NAME = '" & strDBNTUserName & "' AND M.MEMBER_ID = P.M_FROM)"

Set rsPM = my_Conn.Execute(strSql) <---LINE 119
pmtotal1 = rsPM("pmtotal1")
pmtotal2 = rsPM("pmtotal2")

rsPM.close
set rsPM = nothing

end if

---