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:

WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997) WebCat2: Formulas.db question (1997) Variable prices and Formulas.db (1997) default value from Lookup (was Grant, please help me) (1997) did I miss anything (1997) Summary search -- speed (1997) Fwd: [WebDNA] function not as expected (2010) Not really WebCat (1997) Hard Questions ? (1997) Email within tmpl ? (1997) Template not found error messages (1997) RE: Re:Signal Raised (1997) Thanks ! (1997) Was AJAX, Now JS, XML, CSS LISTS (2006) [WebDNA] Triggers not working (2011) search context w shownext works! (1997) [OT] MacOs IE5 topmargin and leftmargin bug (2000) [url] link (1998) Relay link (2002) Feature Request: ! character bug correct in [showif[variable]=] (2000)