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:
Summing Fields (1998)
Why don't my carts expire (1998)
Chatroom (2000)
PCS Frames (1997)
triggering an update of two frames (1998)
Reversed words (1997)
Grep (2003)
How about this? (1998)
WCS Newbie question (1997)
Emailer setup (1997)
WebCat2.0 acgi vs plugin (1997)
Signal Raised error (1997)
AAgghh!! Help, please. SSL strikes again. (1997)
Summing fields (1997)
Webstar 1.3.1 PPC (1997)
WebCat2 Append problem (B14Macacgi) (1997)
[WebDNA] anyone get MaxMind geolite city working? (2012)
Running _every_ page through WebCat ? (1997)
[WebDNA] WebDNA Start-up Error (2012)
Sale on wholesale programming services ... (2006)