Re: SKU lookup
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13116
interpreted = N
texte = Hey guys, thanks for the help, I'll try those out and see what I come up with!Kenneth Grome wrote: > > >Heh Dan: > > > >I like your post! How about this hack which I think will work. > > > > > > > >[search db=yourdatabase.db&grskudata=0&deskusort=1&max=1] > > [founditems] > > [math]newsku=[sku]+1[/math] > > [/founditems] > >[/search] > > > >
Final value=[math]newsku[/math]
> > > > > > > >This will sort in decending order, find only 1 (so the highest number) > >and then assign it to newsku plus one. > > Hey Olin, > > This is exactly what I was going to suggest in the first place! :) > > ... but then I didn't know if Damien really needed incremented sku > values or not, so I thought I would show him the [cart] technique > first, since it's the easiest and fastest to code. > > But hey, if the goal is to append records with each new record's sku > value incremented one higher than the highest existing sku in the > database, your code above can be modified just a little, and then > integrated into an append context as follows: > > [append db=yourdatabase.db]sku=[search > db=yourdatabase.db&grskudata=0&deskusort=1&max=1][founditems][math][sku]+1[/math > ][/founditems][/search] > > Sincerely, Ken Grome > WebDNA Solutions > http://www.hui.net/dna/webdna.html-- _ __( )_ While Eeyore frets ... ( (o____ and Piglet hesitates ... | | and Rabbit calculates ... | (__/ and Owl pontificates \ / ___ / \ \___/ / ^ / \ ...Pooh just is. | | |__|_HUNNY | | \______)____/ \ / \ /_ Damien Joldersma | ( __) p00h@wcug.wwu.edu (____) http://www.wcug.wwu.edu/~p00h
Associated Messages, from the most recent to the oldest:
Hey guys, thanks for the help, I'll try those out and see what I come up with!Kenneth Grome wrote: > > >Heh Dan: > > > >I like your post! How about this hack which I think will work. > > > > > > > >[search db=yourdatabase.db&grskudata=0&deskusort=1&max=1] > >
[founditems] > >
[math]newsku=[sku]+1[/math] > > [/founditems] > >[/search] > > > >
Final value=[math]newsku[/math]
> > > > > > > >This will sort in decending order, find only 1 (so the highest number) > >and then assign it to newsku plus one. > > Hey Olin, > > This is exactly what I was going to suggest in the first place! :) > > ... but then I didn't know if Damien really needed incremented sku > values or not, so I thought I would show him the
[cart] technique > first, since it's the easiest and fastest to code. > > But hey, if the goal is to append records with each new record's sku > value incremented one higher than the highest existing sku in the > database, your code above can be modified just a little, and then > integrated into an append context as follows: > > [append db=yourdatabase.db]sku=[search > db=yourdatabase.db&grskudata=0&deskusort=1&max=1]
[founditems][math][sku]+1[/math > ][/founditems][/search] > > Sincerely, Ken Grome > WebDNA Solutions > http://www.hui.net/dna/webdna.html-- _ __( )_ While Eeyore frets ... ( (o____ and Piglet hesitates ... | | and Rabbit calculates ... | (__/ and Owl pontificates \ / ___ / \ \___/ / ^ / \ ...Pooh just is. | | |__|_HUNNY | | \______)____/ \ / \ /_ Damien Joldersma | ( __) p00h@wcug.wwu.edu (____) http://www.wcug.wwu.edu/~p00h
Damien Joldersma
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:
Using Plug-In while running 1.6.1 (1997)
watch out for format_to_days on NT (1997)
WebCat Documentation (was [platform] tag?) (1998)
Feature req. (2002)
Price and Formula.db (2002)
Trouble serving graphics on protected templates (1998)
WebCatalog can't find database (1997)
credit card (1997)
Text data with spaces in them... (1997)
rotating thumbnails (1997)
WC on Mac OS X or Mac OS X Server 2.x (2001)
Shorthand for command args (1998)
[cart] not being interpreted inside [founditems] (1997)
Draft Manual, Tutorial, and more (1997)
Dummy Credit Card Number for debug? (1997)
[SearchString] problem with [search] context (1997)
Payflow Pro Jar (2002)
Number of Open Databases (1998)
using showpage and showcart commands (1996)
Text limits in NT version? (1997)