Re: Sorting like UBB

This WebDNA talk-list message is from

2003

It keeps the original formatting. numero = 52945
interpreted = N
texte = Well, just figured out this half-baked solution, I'm sure there's a betterone though:[searchdb=scenario_notes.db&nescenskudatarq=[blank]&pdatesort=1&pdatesdir=de&pdatetype=de&ptimesort=2&ptimesdir=de&ptimetype=time][founditems][text show=f]hisku=[searchdb=scenario_notes.db&eqscenskudatarq=[scensku]&deskusort=1&skutype=num&max=1][founditems][sku][/founditems][/search][/text][hideif [sku]![hisku]][sku], [scensku], [strName], [pdate], [ptime]
[/hideif][/founditems][/search]Gary Krockover wrote:> 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:

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

Well, just figured out this half-baked solution, I'm sure there's a betterone though:[searchdb=scenario_notes.db&nescenskudatarq=[blank]&pdatesort=1&pdatesdir=de&pdatetype=de&ptimesort=2&ptimesdir=de&ptimetype=time][founditems][text show=f]hisku=[searchdb=scenario_notes.db&eqscenskudatarq=[scensku]&deskusort=1&skutype=num&max=1][founditems][sku][/founditems][/search][/text][hideif [sku]![hisku]][sku], [scensku], [strName], [pdate], [ptime]
[/hideif][/founditems][/search]Gary Krockover wrote:> 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!

Re: Sorting like UBB

2003

Top Articles:

Related Readings: