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 generate unique sku values automatically - it's called the [cart] tag.Every time you create a new record, you can make WebCatalog create a unique sku value for that record simply by putting sku=[cart] into the form or hyperlink or context that creates the new record. Here are three simple examples to help get you started ... Hyperlink example:append a new record Form example:
Context example:[append db=somedatabase.db]sku=[cart][/append]Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html Associated Messages, from the most recent to the oldest:

    
  1. Re: SKU lookup (Damien Joldersma 1997)
  2. Re: SKU lookup (Kenneth Grome 1997)
  3. Re: SKU lookup (Olin 1997)
  4. Re: SKU lookup (Kenneth Grome 1997)
  5. Re: SKU lookup (Daniel Cameron 1997)
  6. Re: SKU lookup (Damien Joldersma 1997)
  7. Re: SKU lookup (Kenneth Grome 1997)
  8. SKU lookup (Damien Joldersma 1997)
>>>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 generate unique sku values automatically - it's called the [cart] tag.Every time you create a new record, you can make WebCatalog create a unique sku value for that record simply by putting sku=[cart] into the form or hyperlink or context that creates the new record. Here are three simple examples to help get you started ... Hyperlink example:append a new record Form example:
[cart]>
Context example:[append db=somedatabase.db]sku=[cart][/append]Sincerely, Ken Grome WebDNA Solutions http://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:

[WriteFile] problems (1997) Download URL & access on the fly ? (1997) Date Comparison (1998) FlushDatabase Suggestion (1998) Passing Variable (was How to add product size) (1997) Date search - yes or no (1997) [quantity] within formulas (1997) ShowNext Command (1997) WebCatalog Programmer looking for a new job (2001) Bug Report, maybe (1997) WebCat2_Mac RETURNs in .db (1997) videos.. yak..yak (1998) Need relative path explanation (1997) Converting characters to numbers ... (1997) RE: [BULK] [WebDNA] WebDNA Code and HTML WYSIWYG Editors (2011) Order not created error (1997) selectively replacing records within a [founditems] (2000) NEW INFO: I'm stuck: Can't open order (2000) [FoundItems] solved - thanks (1997) carriage returns in data (1997)