| T O P I C R E V I E W |
| leatherlips |
Posted - 01 April 2008 : 13:30:35
I know this has been asked many times, but there has never an answer that seems to work. Has anyone ever successfully been able to show complete posts outside of the forum? I want certain topics and all of their posts to show up on other pages in my site. I've used the mod that allows it to show the latest topics, but that is not what I am looking for.< |
| 15 L A T E S T R E P L I E S (Newest First) |
| AnonJr |
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...< |
| leatherlips |
Posted - 07 April 2008 : 10:13:16
AnonJR, Did you get a chance to figure anything out yet? I appreciate the help you are giving me!< |
| Jezmeister |
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 |
Posted - 06 April 2008 : 08:15:56
Here is a copy of my RSS file in text format.
I really appreciate all of the help you guys are giving me! You guys are great!
Ultimately what I want to appear on my discography page (which is outside of the forum) is the members name and date they posted and the topic and all replies. I'd also like to get the order to show the newest post at the top.
I also noticed that sometimes the Forum code does not quite work in the page outside of the forum. For example is shows the forum tags such as [url ] [/ url].
< |
| Jezmeister |
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.< |
| AnonJr |
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.< |
| leatherlips |
Posted - 05 April 2008 : 21:01:35
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?< |
| leatherlips |
Posted - 05 April 2008 : 18:46:50
quote:
Originally posted by AnonJr
Just for reference, do you have one of the RSS MODs installed in your forum?
I did install an RSS mod awile ago. I don't remember which one. I really only ended up using the rss.asp page I think.
Jezmeister:
Thanks for your ideas. I'll try them out and see what happens. 
I'm willing to go in any direction that ends up getting the results I want whether it be through FP or RSS or whatever else...  < |
| Jezmeister |
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  < |
| AnonJr |
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?< |
| leatherlips |
Posted - 05 April 2008 : 14:56:25
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?< |
| Jezmeister |
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 |
Posted - 05 April 2008 : 12:01:45
I'm making some progress. I use FrontPage 2003 for my website (I know, boo ). Anyway, I decided to try its Database Results Wizard. I have it working so far with the exception of the member ID. Instead of showing the members name, it shows their ID number. Any ideas how to tweak that? What field shows their ID name?
Here is the page I am testing this on:
http://www.mangionemagic.com/discography/togetherforever2.asp#reviews
Everything in this section is coming from the forum page.< |
| Classicmotorcycling |
Posted - 05 April 2008 : 02:12:07
I did something like this a few years ago for a site at: http://www.ozcruize.com
which I made it so they could select the topic on the front page as and example it currently uses the following topic: http://www.ozcruize.com/forum/topic.asp?TOPIC_ID=2375< |
| salondon |
Posted - 03 April 2008 : 10:08:15
simple suggestion would be to use a link such as CD Review. clicking the link will take user to that topic page. otherwise to pull from db hav to use modified topic.asp.< |
