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 usingfldNumDatetype=num.Also, you could use broken dates here such as[math]{[date]} + ({[time]} / 86400)[/math] which will be sortable bydate & 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:
|
- Re: Sort Issues (Peter Werno 2000)
- 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 usingfldNumDatetype=num.Also, you could use broken dates here such as[math]{[date]} + ({[time]} / 86400)[/math] which will be sortable bydate & 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)