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:

WebDNA for Dummies (2004) listfiles shows invisible files ... (1999) Bug Report, maybe (1997) Problems appending to database (1997) OT: advice on Wintel server options (1998) Server slowing down. (1997) problem with waitForFile? (1998) Grouping search fields, etc. (1997) PARAMETER vs. OPERATOR (was The BUG is BACK ...) (1998) Summing fields (1997) filemaker - orderfile (1997) Fufillment e-mail? (1998) Searching on 3 different fields *CORRECTION* (2003) Authorize.Net and AIM (2004) watch out for format_to_days on NT (1997) WebCat2: multiple currency support (1997) WebCat2b13MacPlugin - nested [xxx] contexts (1997) numfound question (2005) Order not created error (1997) Text variables do not show (1999)