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 most recently posted message, showing each topic only once. Sounds easy, I'm perplexed. Here's the fields in the db: sku scensku strName handle pass hide pdate ptime notes keep Where 'sku' is an incrementing number based on the post number, 1 would be the first post, and the highest sku would be the last post. scensku = the topic number strName= the topic title handle/pass/hide/keep you can ignore not used at this point pdate / ptime are the date/time of the post as recorded by [date] and [time] notes is the actual message So, 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 each scensku (most recent post per scensku) and that list again sorted by pdate/ptime in descending order. I take it some serious nesting may be involved here. I'll figure it out eventually, but hoping that someone that has built a BB system may have worked this out already. Yes, I know there's BB systems available, but that is overkill for my needs, this is a simple post a message thing that doesn't need administration or emailing or smiley's or anything fancy. Page in question can be found at www.the-proving-grounds.com/discussions.html (yes, my alternate row coloring is whacked as well). Also hoping to do this without resorting to a temp.db if 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:

    
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 most recently posted message, showing each topic only once. Sounds easy, I'm perplexed. Here's the fields in the db: sku scensku strName handle pass hide pdate ptime notes keep Where 'sku' is an incrementing number based on the post number, 1 would be the first post, and the highest sku would be the last post. scensku = the topic number strName= the topic title handle/pass/hide/keep you can ignore not used at this point pdate / ptime are the date/time of the post as recorded by [date] and [time] notes is the actual message So, 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 each scensku (most recent post per scensku) and that list again sorted by pdate/ptime in descending order. I take it some serious nesting may be involved here. I'll figure it out eventually, but hoping that someone that has built a BB system may have worked this out already. Yes, I know there's BB systems available, but that is overkill for my needs, this is a simple post a message thing that doesn't need administration or emailing or smiley's or anything fancy. Page in question can be found at www.the-proving-grounds.com/discussions.html (yes, my alternate row coloring is whacked as well). Also hoping to do this without resorting to a temp.db if 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!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

WebDNA Codes in Secure Mode (1997) carriage returns in data (1997) Date Formats (1997) SSL problems (1998) WebCat2b13MacPlugIn - syntax to convert date (1997) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) PCS Frames (1997) IIS4/IIS3 and WebCatalog registry settings (1998) repost: I'd like the image this chunk of WEBDNA returns to behyperlinked to the (2000) Browser Problem?!? Still getting Error message using POST! (1997) all records returned. (1997) Can't use old cart file (was One more try) (1997) [WebDNA] Brian Harrington (2019) en/decrypt with authenticate (2000) Interesting speed comparison .. (2003) Please post more "exceptions to the rules" ... (2005) WebCatalog2 Feature Feedback (1996) UPDATE PROBLEM (1997) RE: [WebDNA] Sorry WebDNA server not running /Template ERROR/ Slow (2019) Professional WebDNA Hosting Solutions (2005)