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:

Bulletin Board.... (2000) 2.0Beta Command Ref (can't find this instruction) (1997) Credit card processing - UK (1997) Mime Headers for Mail (1998) Email notification to one of multiple vendors ? (1997) Logging purchases (1997) RE: Missing contexts on NT (1997) Quick ShowIf question (1997) Where's Cart Created ? (1997) multi-table date sort problem thingy (2002) flushdatabases (1997) More on the email templates (1997) Interfacing WC with mail server (1998) Rounding problem (1998) Feedback Please (2003) Problems with webcat 2.01 for NT (1997) Protect (1997) User/pass with tcpconnect (2000) won't serve .tpl (2000) Cart Numbers (1997)