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:

[search] in formulas.db (1997) [LOOKUP] (1997) Problems getting parameters passed into email. (1997) Another new bug found ... (2000) Banners (1997) emailer setup (1997) WebTV, IPAddress, Cookies, IDEAS?? (1998) shownext & math (1997) Problems with SELECT MULTIPLE (1999) Date search and sendmail (1997) Multi-processor Mac info ... (1997) 2.0 Info (1997) WebCatalog NT (1996) [WebDNA] WebDNA 7 (2011) I am sorry for always being such an ass (2004) webcat 2.1 new cart fields - please explain more (1998) Reversed words (1997) Sorting Date (2004) label?! (2005) Writefile (2000)