Sorting like UBB

This WebDNA talk-list message is from

2003

It keeps the original formatting. numero = 52944
interpreted = N
texte = Ok, it's been a long day (ask Ron @ inkblotmedia what kind of day it was)...Anyways, needing to sort a list of topics by the topic with the mostrecently posted message, showing each topic only once. Sounds easy, I'mperplexed.Here's the fields in the db:sku scensku strName handle pass hide pdate ptime notes keepWhere 'sku' is an incrementing number based on the post number, 1 would bethe first post, and the highest sku would be the last post.scensku = the topic numberstrName= the topic titlehandle/pass/hide/keep you can ignore not used at this pointpdate / ptime are the date/time of the post as recorded by [date] and [time]notes is the actual messageSo, I want to only show 1 instance of scensku (scenskusumm=T at some point)and I want it to show scensku sorted by the highest sku number for eachscensku (most recent post per scensku) and that list again sorted bypdate/ptime in descending order. I take it some serious nesting may beinvolved here.I'll figure it out eventually, but hoping that someone that has built a BBsystem may have worked this out already. Yes, I know there's BB systemsavailable, but that is overkill for my needs, this is a simple post amessage thing that doesn't need administration or emailing or smiley's oranything fancy.Page in question can be found atwww.the-proving-grounds.com/discussions.html (yes, my alternate row coloringis whacked as well). Also hoping to do this without resorting to a temp.dbif at all possible.Thanks in advance,GK-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: Sorting like UBB ( "Gary Krockover" 2003)
Sorting like UBB ( "Gary Krockover" 2003)

Ok, it's been a long day (ask Ron @ inkblotmedia what kind of day it was)...Anyways, needing to sort a list of topics by the topic with the mostrecently posted message, showing each topic only once. Sounds easy, I'mperplexed.Here's the fields in the db:sku scensku strName handle pass hide pdate ptime notes keepWhere 'sku' is an incrementing number based on the post number, 1 would bethe first post, and the highest sku would be the last post.scensku = the topic numberstrName= the topic titlehandle/pass/hide/keep you can ignore not used at this pointpdate / ptime are the date/time of the post as recorded by [date] and [time]notes is the actual messageSo, I want to only show 1 instance of scensku (scenskusumm=T at some point)and I want it to show scensku sorted by the highest sku number for eachscensku (most recent post per scensku) and that list again sorted bypdate/ptime in descending order. I take it some serious nesting may beinvolved here.I'll figure it out eventually, but hoping that someone that has built a BBsystem may have worked this out already. Yes, I know there's BB systemsavailable, but that is overkill for my needs, this is a simple post amessage thing that doesn't need administration or emailing or smiley's oranything fancy.Page in question can be found atwww.the-proving-grounds.com/discussions.html (yes, my alternate row coloringis whacked as well). Also hoping to do this without resorting to a temp.dbif at all possible.Thanks in advance,GK-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ "Gary Krockover"

DOWNLOAD WEBDNA NOW!

Sorting like UBB

2003

Top Articles:

Related Readings: