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:
[WebDNA] writing pdfs on the fly (Avery labels #5160) (2010)
Initiating NewCart (1997)
referrer variable (1997)
Help! WebCat2 bug (Ben's input) (1997)
For those of you not on the WebCatalog Beta... (1997)
4.5 Upgrade (2003)
WebCat virtual postcard is done! Thanks for the help! (1998)
Upload Maximum (2003)
all records returned. (1997)
Problems with [Search] param - Mac Plugin b15 (1997)
Upload (1998)
virtual virtual hosted store.... (1998)
Catalogs and W* (1996)
Emailer (1997)
Server crash (1997)
Explorer 3.0/ Access Denied! (1997)
SSL and reg web* (1997)
E-mail/Invoice (1998)
OFF TOPIC: help wanted (1997)
2 easy questions re: [showif] and [sendmail] (1997)