Database Results Wizard (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

leatherlips -> Database Results Wizard (4/5/2008 20:10:19)

I am trying to use the Database Results Wizard to display some information on my page from a database. I am using FrontPage 2003. The database I am trying to draw from is from a Snitz Forum database.

So far I have things working with the exception of an item or two.

I am wanting to display the author of a topic. With the wizard, it only displays the record number of the member and not their name.

The database has multiple tables in them. The wizard seems to only let you select one of those tables. There is a custom query section in the wizard that may do what I want if only I knew how to properly input the command. I have no idea how to do that.

I realize this may not be a very good explanation of my needs. I can explain more if needed. Any ideas?



BeTheBall -> RE: Database Results Wizard (4/5/2008 20:34:20)

Your query would be something like this:

SELECT Author FROM Table1 INNER JOIN Table2 ON Table1.authorID = Table2.authorID

Obviously I don't know your table or field names, but the above is a general idea of how it's done.



leatherlips -> RE: Database Results Wizard (4/5/2008 20:54:12)

Thanks for your quick response!

My Table 1 is called FORUM_TOPICS. The author name column is T_AUTHOR.

My Table 2 is called FORUM_MEMBERS. The T_AUTHOR in table 1 is the same as M_MEMBER in table 2.

Is this how I would enter the query?

SELECT T_AUTHOR FROM FORUM_TOPICS INNER JOIN FORUM_MEMBERS ON FORUM_TOPICS.T_AUTHOR = FORUM_MEMBERS.M_MEMBERS



BeTheBall -> RE: Database Results Wizard (4/6/2008 18:59:30)

That should do it. You may need a WHERE clause if you are trying to get just one specific author.



leatherlips -> RE: Database Results Wizard (4/7/2008 14:22:18)

I am still having trouble getting this to work. Here is what I need to show up from the database; perhaps you can tell me the exact code to insert into the custom querey? I do not know anything about this stuff... [:(]

From a table called Forum_TOPICS I need to show the following fields: T_TOPIC, T_AUTHOR, and T_DATE.

From another table called FORUM_REPLIES I need to show the following fields: R_REPLIES, R_AUTHOR and R_DATE.

The challenging part is that both T_AUTHOR and R_AUTHOR equal a field in another table called FORUM_MEMBERS. The field they reference to is called M_NAME.

Does this make any sense? [8D]



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625