Hi,guys
the code below can display the latest posts of forum in version 6.x. but, after I updated to version 7, it returns me:
"Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters. "
So, how i can fix it? Thanks.
<code>
strSQL = "SELECT Top " & NumOfNewest & " tblTopic.Forum_ID, tblTopic.Topic_ID, " & _
"tblTopic.Subject, tblForum.Forum_name, " & _
"(SELECT MAX(Thread_ID) FROM tblThread WHERE Topic_ID = tblTopic.Topic_ID) AS LastThread, " & _
"(SELECT Count(Thread_ID) FROM tblThread WHERE Topic_ID = tblTopic.Topic_ID) AS ReplyCount " & _
"FROM tblForum INNER JOIN tblTopic ON tblForum.Forum_ID = tblTopic.Forum_ID WHERE " & _
"((tblForum.Password) Is Null) AND (tblForum.Standard < 3) ORDER BY tblTopic.Last_entry_date DESC"
</code>
Topic Options
Post Options
Thanks(0)
