Re: Auto SKU's
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 33460
interpreted = N
texte = >>How do I set it up so sku's are automatically assigned in my databases? > >In order to assist with this type of request, WebCatalog 4.0 has a >new set of tags in [search] which quickly give you the min, max, avg, >and sum of a numeric field column. You can use this to calculate the >highest sku number and then add 1 to it with a [math] context. > >[search db=blah&neskudata=[blank]] >next sku is: [math][max field=sku]+1[/math] >[/search]We have always been able to do a search to get this value in webcat2 and webcat3 with this code:[search db=blah&neskudata=[blank]&deskusort=1&max=1] next sku is: [math][sku]+1[/math] [/search]So as everyone can see, versions 2 and 3 can do the same thing without needing any of the special new tags in version4 ... ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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:
>>How do I set it up so sku's are automatically assigned in my databases? > >In order to assist with this type of request, WebCatalog 4.0 has a >new set of tags in [search] which quickly give you the min, max, avg, >and sum of a numeric field column. You can use this to calculate the >highest sku number and then add 1 to it with a [math] context. > >[search db=blah&neskudata=[blank]] >next sku is: [math][max field=sku]+1[/math] >[/search]We have always been able to do a search to get this value in webcat2 and webcat3 with this code:[search db=blah&neskudata=[blank]&deskusort=1&max=1] next sku is: [math][sku]+1[/math] [/search]So as everyone can see, versions 2 and 3 can do the same thing without needing any of the special new tags in version4 ... ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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/
Kenneth Grome
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:
Emailer Set Up (1997)
writing db to disk (1997)
WC2f3 (1997)
Webcat2, WebCommerce, Mod 10 etc. (1997)
Problem: 3.0 doesn't update carts (1997)
RE: Unexceling (was I need a smart quote...) (1999)
[ModDate] & [ModTime] ? (1997)
WCS Newbie question (1997)
2 things: CartSweep and Manual (2003)
Date search and sendmail (1997)
Monthly Reports (2000)
WebCatalog for guestbook ? (1997)
Affiliate Program code (2000)
[append] vs. [appendfile] delta + question? (1997)
Sorting by highest number of matches unique to a field (2003)
Search in 2 or more catalogs (1997)
Wanted: Broader string manipulation functions (1997)
[WebDNA] Should I run the installer on an existing 8.x system on Ubuntu 14.04? (2015)
Trouble Searching (1999)
supressing math results (1997)