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:
Basics of tcpconnect (2006)
Using a database with a short url (2000)
Re:listfiles-looking for slick solution (1997)
WebCat2 - [format thousands] (1997)
Some Advise needed (1997)
Secure server question (1997)
How did *you* learn Web Catalog? (2000)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Active Server Code... (1998)
search form problem.. (1997)
Thanks Grant (1997)
PCS Frames (1997)
Banner ads example (1997)
Sendmail truncation in Eudora Clients (1998)
(2000)
Bad card db - *mislabled post* (1999)
OT: javascript for dynamic pulldowns? (1998)
autosensing lanague selection (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Directory Overload (1998)