|
AnhLong
Starting Member
23 Posts |
 Posted - 15 September 2002 : 04:15:31
|
Im just install latest snitz 3.4 and fews 3.4 mods: message icons, activeuser mod, adminemail all user mod, and when i go to active topics i get this:
Microsoft JET Database Engine error '80040e14'
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
/active.asp, line 306
----------------
strSql = strSql & ") "
strSql = strSql & " ORDER BY C.CAT_ORDER, C.CAT_NAME, F.F_ORDER, F.F_SUBJECT, T.T_LAST_POST DESC "
Set rs = Server.CreateObject("ADODB.Recordset")
if strDBType <> "mysql" then rs.cachesize = 50
rs.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
if rs.EOF then
recActiveTopicsCount = ""
else
------------------------
those is 303-312 can some one take a look for me
Thanks |
|
Topic Locked
