|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
 Posted - 31 May 2002 : 16:56:01
|
Hi all,
i got this error in members.asp and carnt figuare it out...can somone plz help me??
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'FORUM_MEMBERS.M_DATE FORUM_MEMBERS.M_PMRECEIVE'.
/nbts1/members.asp, line 221
thats the error
end if
else 'end MySql specific code
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.cachesize = strPageSize
rs.open strSql, my_conn, 3 <===========line 221
if not (rs.EOF or rs.BOF) then '## No members found in DB
rs.movefirst
rs.pagesize = strPageSize
maxPages = cint(rs.pageCount)
maxRecs = cint(rs.pageSize)
rs.absolutePage = myPage
maxpages = cint(rs.pagecount)
end if
any ideas???
thankx
MaD2ko0l
© 1999-2002 MaD2ko0l
-=[ Life Is So Easy When You Are Evil ]=-
Edited by - Davio on 31 May 2002 18:49:48 |
|
Topic Locked
