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:
WebDNA on Intel Mac? (2006)
Dashes and dots in credit card (1998)
exact word search (1998)
WC2b15 File Corruption (1997)
Exclamation point (1997)
WebCatalog NT beta 18 problem (1997)
[WriteFile] problems (1997)
Normalizing Dates and Phone numbers (2000)
[FoundItems] solved - thanks (1997)
Attention all list readers (1997)
SiteGuard Admin Feature ? (1997)
PCS Frames (1997)
another problem (1997)
FWD: WebCatalog and .TMPL (1997)
RE: Web*SSL and WebCatalog (1997)
WebCat2b15MacPlugin - showing [math] (1997)
[OT] cheap software (2004)
authenticate and password (1998)
WebCat for Unix?? (1997)
WebCatalog2 Feature Feedback (1996)