Database Discussion - Tables and rows in wwforum.mdb

Print Page | Close Window

Tables and rows in wwforum.mdb

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8023
Printed Date: 30 March 2026 at 7:27am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Tables and rows in wwforum.mdb

Posted By: jimdmurphy
Subject: Tables and rows in wwforum.mdb
Date Posted: 12 December 2003 at 1:15am

I am working on adding the Topic.Subject to default.asp so that the last subject is displayed with the Last Author and Date/Time. I am wondering where to go to find information on the field names for the Tables in wwforum.mdb.

I am specifically interested in Author, Thread and Topic. (I don't have a current version of Access on my PC)

Replies:

Posted By: jimdmurphy
Date Posted: 30 December 2003 at 2:06am

any help on this would be appreciated

Posted By: Tegwin
Date Posted: 30 December 2003 at 2:55am

I would say have a look in Access to see what the field names are that you are looking for. And then do a search (windows) for all files containing those filed names and work from there..

-------------
If you dont want my peaches, dont shake my tree

Posted By: gavinc
Date Posted: 30 December 2003 at 4:36am

I changed default.asp on my site to do what you're after and a bit more. http://www.crsc.co.uk/forum/default.asp - www.crsc.co.uk/forum/default.asp

First thing I did was to change the select statement to make sure that the subject was returned from the database:

strSQL = "select tblThread.Thread_ID, tblThread.message_date, tblThread.topic_id, tblTopic.subject, tblAuthor.Author_ID, tblAuthor.Username"
strSQL = strSQL & " from tblThread, tblTopic, tblAuthor"
strSQL = strSQL & " where tblTopic.Forum_ID = " & intForumID
strSQL = strSQL & " AND tblThread.Topic_ID = tblTopic.Topic_ID" strSQL = strSQL & " AND tblThread.Author_ID = tblAuthor.Author_ID" strSQL = strSQL & " order by message_date desc"

Then I set up a new variable to store the subject title in:

strLastEntrySubject = rsCommon("Subject")

All that was left then was to display the subject title.

I was going to copy in the relevant code at this point but the formatting went all screwy since I was pasting in HTML tags. Drop me a PM with your email address and I will send my default.asp over.

Hope this helps.