| Author |
 Topic  |
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
 Posted - 05 April 2008 : 13:53:12
|
| the topics/posts tables don't have names in there - if they did you wouldn't be able to change member usernames or easily deal with posts of deleted members with n/a etc. you have to query the members table against the ID of the poster to return the member name/rank/details :)< |
 |
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 05 April 2008 : 17:29:46
|
There's probably a way...
I'd started looking at just writing an RSS aggrigator that would consume a feed of the chosen topic. I've got all the bits of code, just not stitched together in a way you can use. I'll probably get a chance to work on it tonight while I'm working on my sister's laptop. This has been one of those weeks.... =/
Just for reference, do you have one of the RSS MODs installed in your forum?< |
|
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 05 April 2008 : 18:00:50
|
quote:
Originally posted by leatherlips
FrontPage is inserting this for the author of the post:
<%=FP_FieldVal(fp_rs,"T_AUTHOR")%>
Is there anything here I could add to make it recognize the members username?
Just in case you decide to continue with this rather than go with mr jr's suggestions: I'm not familiar enough with the way frontpage does this sort of stuff to tell you how to do it with that, so I'll give you two bits of info, hopefully one will be useful to you :P
1) - If you do this just using FP as I think you have been atm (wysiwyg-esque rather than direct coding): To construct the query to get the username you need to, within the loop for returning the post/topic query the member table where ID = fp_rs("T_AUTHOR") (for the bit of code you gave) and return M_NAME from that query.
2) - code example to just insert into your code to return it:
strSql = "SELECT M_NAME FROM "& strMemberTablePrefix &"MEMBERS WHERE MEMBER_ID="& fp_rs("T_AUTHOR")
strName = my_Conn.execute(strSql)
From that strName will now hold the username for you, remember that has to be after the row is selected when you use it for a selection of posts rather than just for the initial topic message, so after something like 'do until fp_rs.eof'
Hope that helps  < |
Edited by - Jezmeister on 05 April 2008 18:02:11 |
|
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 06 April 2008 : 01:24:26
|
There's a function in inc_func_secure.asp there is a function called "getMemberName()" That you can use (or at least use as a template) for getting the member name based on the ID.
Since there's nothing wrong with pursuing multiple plans of attack, do you have a link to a .txt version of your rss.asp? The feed seems a little different than mine and I want to make sure that nothing gets lost in the process.< |
|
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 06 April 2008 : 07:04:55
|
quote:
Originally posted by leatherlips
From another forum I visit that specializes in FrontPage, they suggested this to be but in FP Custom Query wizard:
SELECT Author FROM Table1 INNER JOIN Table2 ON Table1.authorID = Table2.authorID
I translated that to mean:
SELECT *T_AUTHOR FROM FORUM_TOPICS INNER JOIN FORUM_MEMBERS ON FORUM_TOPICS.T_AUTHOR = FORUM_MEMBERS.M_NAME
However, it is not working either. Am I referencing the correct tables and fields?
SELECT M_NAME FROM FORUM_MEMBERS INNER JOIN FORUM_TOPICS ON FORUM_MEMBERS.MEMBER_ID = FORUM_TOPICS.T_AUTHOR
The above should do what the query was intended to (although not neccesarily what you want it to)
-> just a sidenote for future :) asterisk is a wildcard which gets you everything that fits the criteria rather than a specific field, there's no point in putting it and then defining the field you want.
What I'll say against doing that is that it's a long way round a simple operation and unless you're doing a little more with it than the above query i'm not sure it's gonna throw back what you want.
I completely forgot about getMemberName  but you can use that, or again just the simple query I posted (which you can just add anywhere after frontpage did the initial query of FORUM_TOPICS and before you print out the name) - I think those'd probably be easier for you, although possibly not as easy as the RSS, there's a lot of simple ASP code for aggregating RSS so long as you can get the right results from the RSS page.< |
|
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 06 April 2008 : 11:49:25
|
quote:
and pass the posts through FormatStr if you want links etc to stay intact in your new page.
eg "& formatStr(strPost) &"< |
|
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 April 2008 : 12:50:19
|
| I got a start on it last night, but I didn't get much further. It ended up being a busier weekend than I'd anticipated...< |
|
|
|
Topic |
|
Posts Outside of Forum
<