The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
hiya,
as the title says, i want to select R_REPLY from the Reply table. and i dont know how to incorporate it into the current select statement where it is selecting the topics.
can anyone help me?
thansk
MaD2ko0l<
as the title says, i want to select R_REPLY from the Reply table. and i dont know how to incorporate it into the current select statement where it is selecting the topics.
can anyone help me?
thansk
MaD2ko0l<
© 1999-2010 MaD2ko0l
Postet den
what is R_REPLY ?<
Postet den
DOH!
i mean R_AUTHOR from the REPLY table<
i mean R_AUTHOR from the REPLY table<
© 1999-2010 MaD2ko0l
Postet den
ok, why do you want/need this in forum.asp ? forum.asp does not have any replies only topics.<
Postet den
© 1999-2010 MaD2ko0l
Postet den
I'm not sure I agree with your thinking, for a start forum.asp already tells you if you are the author, your name is listed as the author, but hey, if you want to slow your forum down who am I to stop you.
I would write a function to which you pass the member_id and the forum_id and the topic_id and return true/false if you post in it, in the function you need a simple query like below (not tested obviously)
SELECT REPLY_ID FROM FORUM_REPLY WHERE FORUM_ID=ForumId AND TOPIC_ID=TopicId AND R_AUTHOR=MemberId
ForumId,TopicId and MemberId are the values you passed to the function, if the query returns any results then you made a post in that topic.<
I would write a function to which you pass the member_id and the forum_id and the topic_id and return true/false if you post in it, in the function you need a simple query like below (not tested obviously)
SELECT REPLY_ID FROM FORUM_REPLY WHERE FORUM_ID=ForumId AND TOPIC_ID=TopicId AND R_AUTHOR=MemberId
ForumId,TopicId and MemberId are the values you passed to the function, if the query returns any results then you made a post in that topic.<
Postet den
hiya,
i know forum.asp tells u if u r the author, but what i am trying to do is to get forum.asp to tell me if i have posted a reply in a topic.
will try the code in a bit<
i know forum.asp tells u if u r the author, but what i am trying to do is to get forum.asp to tell me if i have posted a reply in a topic.
will try the code in a bit<
© 1999-2010 MaD2ko0l
Postet den
I got this to work by counting the replies in the topic sql.
I can only test with a mySql db and from experiece with some of my other mods I doubt it will work with access.
If you want I'll get the files together for you.
<
<
_-/Cripto9t\-_
Postet den
yes please...it may help me out.
greatly apreciated<
greatly apreciated<
© 1999-2010 MaD2ko0l
Postet den
I think I got everything.
Right click and Save.
If you are using any db other than MySql5 you may recieve an error, but maybe one of the local db gurus can help
.<
_-/Cripto9t\-_
Postet den
yes i get a
Syntax error in JOIN operation
:-(<
Syntax error in JOIN operation
:-(<
© 1999-2010 MaD2ko0l
Email Member
Message Member
Post Moderation
Filopplasting
If you're having problems uploading, try choosing a smaller image.
Forhåndsvis post
Send Topic
Loading...