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:
Passing Cart variable to subdirectory files? (1997)
I'm new be kind (1997)
Triggers (2001)
Summing fields (1997)
RE: protect tag on NT (1997)
[WebDNA] help with writefile (2012)
Ken's Data Manager (finally available I think ...) (2005)
FlushDatabase Suggestion (1998)
Nested tags count question (1997)
For those of you not on the WebCatalog Beta... (1997)
Autoreturn Submit? (1997)
Separate SSL Server (1997)
[SHOWIF]s and empty arguments (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Location of Browser Info.txt file (1997)
Sort Order on a page search (1997)
Test (2003)
[SQL] & ODBC on Mac - Reposted (2000)
OS X Problem... (2000)
synching databases on multiple servers (1997)