A Goon
Money is not the most important thing n the world. Love is.Fortunately, I love money.
- Jackie Mason
I've been living in New Brunswick for 17.23 years.
Modified: August 09 2006.
Hits: 8481128/12369721
User: Anonymous Coward
Time: 0.01 seconds.

Read Message

okie dokie.

Author: Tridus ()
Date: 2000-04-03 00:00:00

Ok, there is two of them right now (I want to make it one). The first one grabs all the top level posts, and here it is:

"SELECT userindex,username,tag1,tag2,tag3,postindex,posttype,subject,date,time,nt,ot,authenticated,anonymousid,views,parent FROM posts,users WHERE posts.posterid = users.userindex AND posts.parent = 0 ORDER BY posts.date DESC, posts.time DESC"

(the date selector is also in there normally, but I took it out to make it a bit easier to read)

now since I have that in a view right now, I use something like "select * from threadlist", but thats the base query right there. The second query is the same, except its where posts.parent <> 0, as its the one used to grab all the replies.

Now what happens is whenever I try to print replies, it runs a filter on the ADO recordset returned by the second query so the only thing left is the replies to the current message. Alternately, I could also requery the database using "AND posts.parent = postindex_of_message_calling_this_query", and get the same results.

If there were no words, no way to speak... I would still hear you... - Martina McBride

bloody hell! - Tridus - 2000-04-03 00:00:00
-Post the query - The Lord DebtAngel - 2000-04-03 00:00:00
--okie dokie. - Tridus - 2000-04-03 00:00:00
-grrrrrr.... nice link --\/ (do we really want him to have html in his titles?) - rRaminrodt - 2000-04-03 00:00:00
--well... - Tridus - 2000-04-03 00:00:00
---Fear not, I am done with it for now, but be wary of what the future may bring..bwahahaha! - BandWidth - 2000-04-03 00:00:00
----*rests his arms on his big-admin-stick-of-mass-whoop-ass* I think I'm ready. :) - Tridus - 2000-04-03 00:00:00
----hehehe :) - rRaminrodt - 2000-04-03 00:00:00
-----Do you underestimate me mortal? - BandWidth - 2000-04-03 00:00:00
-Well, ok then... - BandWidth - 2000-04-03 00:00:00