Web Wiz Forums - About the latest posts in version 7

Print Page | Close Window

About the latest posts in version 7

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=264
Printed Date: 29 March 2026 at 2:56am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: About the latest posts in version 7

Posted By: feed2cats
Subject: About the latest posts in version 7
Date Posted: 17 February 2003 at 4:50pm

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>

Replies:

Posted By: WebWiz-Bruce
Date Posted: 18 February 2003 at 6:03am

It may work if you take out this part from near the end:-

AND (tblForum.Standard < 3)

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting