Re: serial number generation
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13558
interpreted = N
texte = >Is there an easy way to generate serial numbers using Webcat. I need them>to create Customer number and order references where the value is n+1>each time it is called.If you need to keep an actual database of serial numbers, and if youwant to append a new record to that database every time you need anew serial number, use this WebDNA:[append db=../include/serial.db]sku=[cart]&valeur=[searchdb=../include/serial.db&nevaleurdata=0&devaleursort=1&max=1][founditems][math][valeur]+1[/math][/founditems][/search][/append]If you don't really need a database with all the previously-createdserial numbers in it, but instead you only need to maintain the valueof the largest serial number which has ever been issued, use thefollowing WebDNA instead:[writefile SerialNumber][math][include SerialNumber]+1][/math][writefile]Sincerely, Ken GromeWebDNA Solutionshttp://www.hui.net/dna/webdna.html
Associated Messages, from the most recent to the oldest:
>Is there an easy way to generate serial numbers using Webcat. I need them>to create Customer number and order references where the value is n+1>each time it is called.If you need to keep an actual database of serial numbers, and if youwant to append a new record to that database every time you need anew serial number, use this WebDNA:[append db=../include/serial.db]sku=
[cart]&valeur=[searchdb=../include/serial.db&nevaleurdata=0&devaleursort=1&max=1]
[founditems][math][valeur]+1[/math][/founditems][/search][/append]If you don't really need a database with all the previously-createdserial numbers in it, but instead you only need to maintain the valueof the largest serial number which has ever been issued, use thefollowing WebDNA instead:[writefile SerialNumber]
[math][include SerialNumber]+1][/math]
[writefile]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:
[ShowNext] (1997)
how to allow only *some* html in a db field (2002)
PCS Frames (1997)
Draft Manual, Tutorial, and more (1997)
WebMerchant? (1998)
Emailer setup (1997)
Credit Card not accepted (1998)
Multiple security dbs (1997)
Sort Order on a page search (1997)
Re[2]: Support suggestions - long (was politeness, et al) (2000)
HTML Editors (1997)
New reserved words for [tags] (2000)
CommandSecurity? (1997)
New WebCatalog site (1997)
text size limitation (1997)
FYI: virus alert (1996)
cookies and [returnraw] (1997)
Erotic Sites (1997)
Bug? (1997)
Summing fields (1997)