Re: Auto SKU's
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 33430
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]Technical Support ********************************** Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) 16855 West Bernardo Drive, #380 | ------------------------- San Diego, CA 92127 | Software & Site Development WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 **********************************------------------------------------------------------------- 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]Technical Support ********************************** Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) 16855 West Bernardo Drive, #380 | ------------------------- San Diego, CA 92127 | Software & Site Development WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 **********************************------------------------------------------------------------- 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/
WebDNA Support
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] encoding with webdna/JS, in context of various file encodings/charsets (2010)
select menus & database design (1998)
Locking up with WebCatalog... (1997)
Nested [xxx] contexts & Bad Suffix (1998)
Exclude by date - multiple (1997)
[LOOKUP] (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Re:Searching for ALL / empty form field (1997)
PGP encrypted email (1998)
select menus & database design (1998)
Automated FTP from Shell (2004)
To Err or Not Custom Error (1999)
webcat serving multiple copies of same db from ram (2000)
bug report -- leading < character (1998)
Urgent help needed (1998)
Running _every_ page through WebCat ? (1997)
How to add product size choices to form? (1997)
Nesting WebDNA in JavaScript (2003)
[SearchString] usage (1997)
[WebDNA] PayPal Instant Payment Notification Guide (2009)