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:
>>>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
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:
unable to launch acgi in WebCat (1997)
Fwd: Problems with Webcatalog Plug-in (1997)
[BULK] [WebDNA] A new commerce system for v7+ (2011)
encrypt (2000)
Re[2]: Searchable archives gone again??? (2000)
Automated FTP from Shell - Update (2004)
Alternating BGColors in Table Rows (1998)
Re[2]: Weird [blank] interpretation (1999)
Searching in multiple databases from a form (1999)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
Press Release hit the NewsWire!!! (1997)
SiteEdit Pro Update Announcement (1997)
2.1 Stuff (1998)
Frames (1997)
[WriteFile] problems (1997)
Possible Bug in 2.0b15.acgi (1997)
Problem (1997)
Forbidden CGI Error (1997)
Country & Ship-to address & other fields ? (1997)
Almost a there but..bye bye NetCloak (1997)