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!

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:

RE: is sku a REQUIRED field on NT (1997) [append] (1997) page redirect in webDNA (1997) Decrypt Acting Strange With Form (2004) [include ...] behavior (1997) Help name our technology! I found it (1997) success - serial numbers and webmerch (1997) Order not created error (1997) Strange intermittent WebDNA problems (2008) RE: Cart Template (1997) Problem with webcat install (1998) Add to Cart & List of Products (1997) Emailer Q (2002) Banners (1997) How can I Add several Items into the cart at once? (1997) WC2b12: Yes, Formulas.db is for real (1997) No luck with taxes (1997) TeaRoom Order fields email account remain empty even thoughthewy are filled. (1997) Summary search -- speed (1997) problem serving foreign languages text (1997)