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 you want to append a new record to that database every time you need a new serial number, use this WebDNA:[append db=../include/serial.db]sku=[cart]&valeur=[search db=../include/serial.db&nevaleurdata=0&devaleursort=1&max=1][founditems][math][v aleur]+1[/math][/founditems][/search][/append]If you don't really need a database with all the previously-created serial numbers in it, but instead you only need to maintain the value of the largest serial number which has ever been issued, use the following WebDNA instead:[writefile SerialNumber][math][include SerialNumber]+1][/math][writefile]Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html Associated Messages, from the most recent to the oldest:

    
  1. Re: serial number generation (ltpladys 1997)
  2. Re: serial number generation (John Hill 1997)
  3. Re: serial number generation (Christer Olsson 1997)
  4. Re: serial number generation (Grant Hulbert 1997)
  5. Re: serial number generation (ltpladys 1997)
  6. Re: serial number generation (Kenneth Grome 1997)
  7. serial number generation (ltpladys 1997)
>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 you want to append a new record to that database every time you need a new serial number, use this WebDNA:[append db=../include/serial.db]sku=[cart]&valeur=[search db=../include/serial.db&nevaleurdata=0&devaleursort=1&max=1][founditems][math][v aleur]+1[/math][/founditems][/search][/append]If you don't really need a database with all the previously-created serial numbers in it, but instead you only need to maintain the value of the largest serial number which has ever been issued, use the following WebDNA instead:[writefile SerialNumber][math][include SerialNumber]+1][/math][writefile]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:

[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)