Re: Searching for the end
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21504
interpreted = N
texte = I'm not the one that creates the database, i just do a interface for a tab file that my customer creates and have then made an admin function that closes the current, and writes a new db file with the fields (hdr) and the values (tabfil.db) and then deletes the uploaded tab-fileI know that when they are appending data, its always numerically ascending values, but i am NOT sure that the export they do is!, i just checked it is in random orderAnd actually there is more to it than thatMy SKU field is called VURDERINGSNUMMER and contains values like 98064and then i have a date field called VURDERINGSDATO with dates values as 29/01/1998 (dd/mm/yyyy)The exact thing i need to do is find the last 25 VURDERINGSNUMMER and sort it by date in descending order, so thelast comes firstBut i can't get it to work :-{/Martin >>>I have a db file with a SKU number for each record, >>>i want to make a template that shows only the last 25 > >>If you're sorting by SKU, just add &deSKUsort=1&SKUtype=num&max=25 to >>your search context. > >This suggestion will work only if your SKU's are created as 'numbers' in >numerically ascending order at the time the records are appended to the >database. But the cart tag does *not* generate its values in numerically >ascending order ... so if you used [cart] to create your SKU's, you should >leave out the &SKUtype=num portion of the above example. > >Sincerely, >Ken Grome >808-737-6499 >WebDNA Solutions >mailto:ken@webdna.net >http://www.webdna.net Konsulentfirmaet Bech.dk Dynamic HTML, WebDNA programming, Lasso & Filemaker Pro development
Associated Messages, from the most recent to the oldest:
I'm not the one that creates the database, i just do a interface for a tab file that my customer creates and have then made an admin function that closes the current, and writes a new db file with the fields (hdr) and the values (tabfil.db) and then deletes the uploaded tab-fileI know that when they are appending data, its always numerically ascending values, but i am NOT sure that the export they do is!, i just checked it is in random orderAnd actually there is more to it than thatMy SKU field is called VURDERINGSNUMMER and contains values like 98064and then i have a date field called VURDERINGSDATO with dates values as 29/01/1998 (dd/mm/yyyy)The exact thing i need to do is find the last 25 VURDERINGSNUMMER and sort it by date in descending order, so thelast comes firstBut i can't get it to work :-{/Martin >>>I have a db file with a SKU number for each record, >>>i want to make a template that shows only the last 25 > >>If you're sorting by SKU, just add &deSKUsort=1&SKUtype=num&max=25 to >>your search context. > >This suggestion will work only if your SKU's are created as 'numbers' in >numerically ascending order at the time the records are appended to the >database. But the cart tag does *not* generate its values in numerically >ascending order ... so if you used
[cart] to create your SKU's, you should >leave out the &SKUtype=num portion of the above example. > >Sincerely, >Ken Grome >808-737-6499 >WebDNA Solutions >mailto:ken@webdna.net >http://www.webdna.net Konsulentfirmaet Bech.dk Dynamic HTML, WebDNA programming, Lasso & Filemaker Pro development
Martin Gertz Bech
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:
Sendmail and textarea (1998)
[listfiles] nested in a [loop] (1998)
WebDelivery downloads alias, not original ? (1997)
SASL Support in WebDNA (2004)
Locking up with WebCatalog... (1997)
Online magazine- monthly updates and such (1999)
Special delete ... (1997)
Browser Problem?!? Still getting Error message usingPOST! (1997)
PSC recommends what date format yr 2000??? (1997)
.htaccess to make WebDNA serve HTML (2007)
[WebDNA] listfiles problem (2011)
[middle] (2000)
WebCat2: Found Items syntax, etc. (1997)
WebCatalog for guestbook ? (1997)
New WebCatalog site! (1997)
[WebDNA] directory protection questions (2008)
Can I invoke an ssi plugin from within a webcat page (1997)
Problems searching from a FORM (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
WebCat2 - storing unformatted date data? (1997)