Re: SKU lookup
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13102
interpreted = N
texte = >>>How would one write an expression to lookup the last SKU entry made>>>in a given db, and then add 1 to it, and enter that automatically in the>>>SKU field?>> What record do you want this new SKU value to go into?>> Do you want it to go into a brand new record, or do you want to>> replace the existing SKU value in the last record of the database?>It is for adding new records, I don't want to have to sift through the>entire db to find a unique SKU, so i thought that this would be a good>way to do it. Is there a better way?Yes, and it's really easy, because WebCat has a way to generateunique sku values automatically - it's called the [cart] tag.Every time you create a new record, you can make WebCatalog create aunique sku value for that record simply by putting sku=[cart] intothe form or hyperlink or context that creates the new record. Hereare three simple examples to help get you started ...Hyperlink example:
appenda new recordForm example:
Context example:[append db=somedatabase.db]sku=[cart][/append]Sincerely, Ken GromeWebDNA Solutionshttp://www.hui.net/dna/webdna.html
Associated Messages, from the most recent to the oldest:
>>>How would one write an expression to lookup the last SKU entry made>>>in a given db, and then add 1 to it, and enter that automatically in the>>>SKU field?>> What record do you want this new SKU value to go into?>> Do you want it to go into a brand new record, or do you want to>> replace the existing SKU value in the last record of the database?>It is for adding new records, I don't want to have to sift through the>entire db to find a unique SKU, so i thought that this would be a good>way to do it. Is there a better way?Yes, and it's really easy, because WebCat has a way to generateunique sku values automatically - it's called the
[cart] tag.Every time you create a new record, you can make WebCatalog create aunique sku value for that record simply by putting sku=
[cart] intothe form or hyperlink or context that creates the new record. Hereare three simple examples to help get you started ...Hyperlink example:
appenda new recordForm example:
Context example:[append db=somedatabase.db]sku=
[cart][/append]Sincerely, Ken GromeWebDNA Solutionshttp://www.hui.net/dna/webdna.html
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:
AOL and [referrer] (2001)
[WebDNA] [WSC] WebDNA Development Summit (2014)
Emailer again & again (1997)
Merging databases (1997)
[WebDNA] double emails (2014)
Smart caching problems with 2.1b3? (1997)
WebCatalog can't find database (1997)
grouping fields (1999)
Opposite of Summ=T? (2000)
Add a field to the error log? (1997)
Snake Bites (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Emailer (1999)
Order not created error (1997)
Nested tags count question (1997)
WC2f3 (1997)
TCP/IP connect (1998)
Help name our technology! (1997)
Status of variable hierarchy changes? (2000)
WebCat2b12plugin - [search] is broken ... not! (1997)