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:

$append (1998) multi-paragraph fields (1997) No luck with taxes (1997) MATH PROBLEM (1997) WC1.6 to WC2 date formatting (1997) [WebDNA] triggers executed at boot instead of scheduled time (2011) Nested vs conditional (1997) ListFiles (2000) FORM NONSENSE - WAS: How much is too much? (2002) [date format] w/in sendmail (1997) WebCat2 - [format thousands] (1997) Using the Tearoom Teamplates (2000) Using Applescript to process WebCatalog functions (1998) [WebDNA] [OT] potential cheap WebDNA server? (2009) Re:quit command on NT (1997) Just Testing (1997) select multiple (1997) IP Address (2001) Generating Options for a Form. (1997) Associative lookup style? + bit more (1997)