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:
Multiple prices (1997)
autosensing lanague selection (1997)
MySQL and Numbers (2005)
Command=FlushDatabases Question... (2001)
WebCat2 several catalogs? (1997)
maximu values for sendmail! (1997)
Location of Webcat site in folder hierarchy (1997)
[append] and SSL (1997)
Expected behavior? (1998)
First postarg not taking in $Commands (1997)
emailer (1997)
setcookie getcookie on the same page (2003)
Looking for someone to double check my code... (1999)
Listserver problem (1997)
WebCatalog on G3 Macs? (1997)
[ShowIf] a either fields are blank (1998)
Sort Order on a page search (1997)
emailer don't work (1998)
Country & Ship-to address & other fields ? (1997)
back button problem (1999)