Re: Sort Issue?
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30093
interpreted = N
texte = on 4/5/00 08:47 AM, Jesse Proudman at lists@ninewire.com wrote:> Didn't fill it all out. > ----------------------- > > Allright - Here's what I've got. > > I've got a DB like this: > > GREEK.SKU GREEK.SORTORDER GREEK.GROUPSKU > 0404200001 2 0404200009 > 0404200002 1 0404200002 > 0404200003 2 0404200004 > 0404200004 3 0404200009 > > I want to search through a DB and display the records like this: > > 0404200002 1 0404200002 > 0404200003 2 0404200004 > 0404200001 2 0404200009 > 0404200004 3 0404200009 > > I have my search and sort like this: > > [search > db=data/greek-messages.db&eqgreek.forumiddata=[cat]&GREEK.SORTORDERsort=2&GR > EEK.SORTORDERsdir=as&GREEK.GROPUSKUsort=1&GREEKGROUPSKUsdir=as&allhit=1] > > Any ideas? > > Jesse Proudman - NineWire Productions > http://www.ninewire.com <-> jesse@ninewire.com > Innovative and Creative Web Design and Hosting > > ------------------------------------------------------------- > 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 > you need to have type=num in there (GREEK.GROPUSKUtype=num)otherwise it sorts them alphabetically, where 1, 11, 2 etc ------------------------------------------------------------- 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
Associated Messages, from the most recent to the oldest:
on 4/5/00 08:47 AM, Jesse Proudman at lists@ninewire.com wrote:> Didn't fill it all out. > ----------------------- > > Allright - Here's what I've got. > > I've got a DB like this: > > GREEK.SKU GREEK.SORTORDER GREEK.GROUPSKU > 0404200001 2 0404200009 > 0404200002 1 0404200002 > 0404200003 2 0404200004 > 0404200004 3 0404200009 > > I want to search through a DB and display the records like this: > > 0404200002 1 0404200002 > 0404200003 2 0404200004 > 0404200001 2 0404200009 > 0404200004 3 0404200009 > > I have my search and sort like this: > > [search > db=data/greek-messages.db&eqgreek.forumiddata=[cat]&GREEK.SORTORDERsort=2&GR > EEK.SORTORDERsdir=as&GREEK.GROPUSKUsort=1&GREEKGROUPSKUsdir=as&allhit=1] > > Any ideas? > > Jesse Proudman - NineWire Productions > http://www.ninewire.com <-> jesse@ninewire.com > Innovative and Creative Web Design and Hosting > > ------------------------------------------------------------- > 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 > you need to have type=num in there (GREEK.GROPUSKUtype=num)otherwise it sorts them alphabetically, where 1, 11, 2 etc ------------------------------------------------------------- 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
Aaron Lynch
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:
Need help (1998)
WebCat virtual postcard is done! Thanks for the help! (1998)
PDF Example (2003)
Date Format not working (2004)
change the number format (1997)
Requiring that certain fields be completed (1997)
Re:FYI: Error message (1996)
Firesite cache vs webcat cache (1997)
formula.db, adding option prices (1997)
Ads.db (1997)
$Quit, $CloseDatabase corrections (1997)
Storebuilder Seems to have just died (2003)
Resume Catalog ? (1997)
show all problem (1997)
multiple price line in formula.db (2004)
OT: [WAY IN RIGHT FIELD SOMEWHERE] Spam Filters (2005)
Multiple Passwords (1997)
[showif] / [hideif] (1997)
Is this possible, WebCat2.0 and checkboxes (1997)
Nested tags count question (1997)