Re: Sort Issues

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 35637
interpreted = N
texte = Jesse,probably not a nice way, but I am using a separate field in the Database (which I usually call sth like fldNumDate), in which I store [math]{[date]}[/math]. This field is then a numeric field and can be sorted as you like using fldNumDatetype=num.Also, you could use broken dates here such as [math]{[date]} + ({[time]} / 86400)[/math] which will be sortable by date & time.Ciao,PeteOn Wed, 2 Aug 2000 23:29:10 Jesse Proudman (Lists Account) wrote: > Sort issue. > > Here is my search: > > [search > db=data/db/press.db&geSEARCHDATEdata=1/1/80&SEARCHDATEtype=date&SEARCHDATEsd > ir=as&SEARCHDATEsort=1&max=3] > > and I've also tried: > > [search > db=data/db/press.db&geSEARCHDATEdata=1/1/80&SEARCHDATEtype=date&SEARCHDATEsd > ir=de&SEARCHDATEsort=1&max=3] > > but both sort the records in the same manner? > > I'm searching via date and I want the latest record to show first? > > Any ideas? If this one is obvious, im retiring for the night. :P > > Jesse Proudman - NineWire Digital Solutions > http://www.ninewire.com <> jesse@ninewire.com > Innovative and Creative Digital Solutions > > ****************************************************************** > * NineWire Productions and Digital Speed Networks, have merged!! * > * We are now known as NineWire Digital Solutions! * > ****************************************************************** > > > ------------------------------------------------------------- > 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://search.smithmicro.com/ ------------------------------------------------------------- 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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Sort Issues (Peter Werno 2000)
  2. Sort Issues (Jesse Proudman (Lists Account) 2000)
Jesse,probably not a nice way, but I am using a separate field in the Database (which I usually call sth like fldNumDate), in which I store [math]{[date]}[/math]. This field is then a numeric field and can be sorted as you like using fldNumDatetype=num.Also, you could use broken dates here such as [math]{[date]} + ({[time]} / 86400)[/math] which will be sortable by date & time.Ciao,PeteOn Wed, 2 Aug 2000 23:29:10 Jesse Proudman (Lists Account) wrote: > Sort issue. > > Here is my search: > > [search > db=data/db/press.db&geSEARCHDATEdata=1/1/80&SEARCHDATEtype=date&SEARCHDATEsd > ir=as&SEARCHDATEsort=1&max=3] > > and I've also tried: > > [search > db=data/db/press.db&geSEARCHDATEdata=1/1/80&SEARCHDATEtype=date&SEARCHDATEsd > ir=de&SEARCHDATEsort=1&max=3] > > but both sort the records in the same manner? > > I'm searching via date and I want the latest record to show first? > > Any ideas? If this one is obvious, im retiring for the night. :P > > Jesse Proudman - NineWire Digital Solutions > http://www.ninewire.com <> jesse@ninewire.com > Innovative and Creative Digital Solutions > > ****************************************************************** > * NineWire Productions and Digital Speed Networks, have merged!! * > * We are now known as NineWire Digital Solutions! * > ****************************************************************** > > > ------------------------------------------------------------- > 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://search.smithmicro.com/ ------------------------------------------------------------- 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://search.smithmicro.com/ Peter Werno

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:

2.0 Info (1997) WebDNA for Window 2000 Server (2003) help with grep (2008) [TaxableTotal] - not working with AOL and IE (1997) WebCatalog and directory indexing (1998) webcat license???? (1997) WebCatalog for guestbook ? (1997) Multiple Pulldowns (1997) Server crash (1997) Spamming this list! (2000) New One (for me).... Error type 12 (1999) Populating a db from a form textarea (2005) Discount solution? (1998) Frames and WebCat (1997) How to Display text in empty fields (1997) Uploading very large image files (2003) Introduction/Tutorial/QuickStart (1997) Not really WebCat - need HTML Grider (1997) Replace with Producteditor.tpl (2000) something simple? (1998)