|
| |
|
|
leatherlips
Posts: 247
From: USA
Status: offline
 |
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?
_____________________________
Mangione Magic - The Music Of Chuck Mangione
|
|
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
leatherlips
Posts: 247
From: USA
Status: offline
|
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
_____________________________
Mangione Magic - The Music Of Chuck Mangione
| |
|
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
