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:
CR's (2003)
[shownext] and descending order (1997)
[WebDNA] TCPConnect/cURL alternative for windows? (2010)
WebCatalog can't find database (1997)
Re:Transfer of data from Invoice to thank you templates (1998)
[OT] Mac OSX hardware test software (2004)
WebCatalog-NT?'s (1996)
Selected Item in Pop-down (2003)
WC 3.0.1 Mac days_to_date (1998)
2nd WebCatalog2 Feature Request (1996)
Searchable list archive (1997)
A little syntax help (1997)
[Webcat 2]Next (1997)
ExclusiveLock (2000)
WebCat2b15MacPlugin - showing [math] (1997)
CommitDatabase vs. CloseDatabase (2001)
shipping help (1998)
Who is doing sign-ups (1998)
[include] affect on filepaths for links? (1997)
Access to shopping cart files (2005)