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.
Hi, I'm curious if anybody can help me with this.
I think it can be applied to forums, but I ask it for my
blog thingy.
What I want to do is add an extra field to the database with a value (covered!)
Then when posting a topic the author can select the type of topic, in my case that would be "Blog" or "News" by selecting on of those two a value will stay on 0 or be set to 1.
Now, what I need is to extract the latest 50 topics, which can be ne through this:
strSql = "SELECT TOP 50 T.T_SUBJECT, T.TOPIC_ID FROM " & strTablePrefix & "TOPICS T WHERE T.T_AUTHOR = " & ppMember_ID & " ORDER BY T.TOPIC_ID DESC"
Now, assuming the new field will be called TYPE, then where or how do I need to add the T.TYPE?
In the WHERE part? Like: AND T.TYPE="1" ? to select all fields with the 1 value or is it a bit more complex?
Please let me know.
Greets & thanks, Dominic<
blog thingy.
What I want to do is add an extra field to the database with a value (covered!)
Then when posting a topic the author can select the type of topic, in my case that would be "Blog" or "News" by selecting on of those two a value will stay on 0 or be set to 1.
Now, what I need is to extract the latest 50 topics, which can be ne through this:
strSql = "SELECT TOP 50 T.T_SUBJECT, T.TOPIC_ID FROM " & strTablePrefix & "TOPICS T WHERE T.T_AUTHOR = " & ppMember_ID & " ORDER BY T.TOPIC_ID DESC"
Now, assuming the new field will be called TYPE, then where or how do I need to add the T.TYPE?
In the WHERE part? Like: AND T.TYPE="1" ? to select all fields with the 1 value or is it a bit more complex?
Please let me know.
Greets & thanks, Dominic<
Postet den
Just figured that this could probably be done through a string, as in
if StrTYPE="1" then Response.Write etc.
I'm going to play around with this. If anybody is interested, let me know so I can make a mini mod out of it when ready.
Greets, D
<
if StrTYPE="1" then Response.Write etc.
I'm going to play around with this. If anybody is interested, let me know so I can make a mini mod out of it when ready.
Greets, D
<