Re: Unique SKU Numbers

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 29379
interpreted = N
texte = I use this bit of code in an include. Everytime I need a unique number, I simply [include uniquenumber.incl] -- [lookup db=/db/unum.db&lookinfield=Ucode&value=Ucode&returnfield=Unumber¬found=wibble][replace db=/db/unum.db&equcodedatarq=Ucode]Unumber=[math][lookup db=/db/unum.db&lookinfield=ucode&value=Ucode&returnfield=Unumber]+1[/math][/replace] --This routine also requires a database with the highest used number: -- Ucode[TAB]Unumber Ucode [TAB]991092Simply seed the database with the first number you wish to use, and off you go.Good luck,D. On dinsdag, 21 maart 2000, Aaron Chute wrote: >How are most folks handling unique SKU numbers? Is there a canned >routine that will spin through SKU numbers - then increment by 1 - >and autofill a new record SKU field? > >TIA >Aaron > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
  1. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  2. Re: Unique SKU Numbers (Kenneth Grome 2000)
  3. Re: Unique SKU Numbers (Glenn Busbin 2000)
  4. Re: Unique SKU Numbers (Glenn Busbin 2000)
  5. Re: Unique SKU Numbers (Aaron Chute 2000)
  6. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  7. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  8. Re: Unique SKU Numbers (Glenn Busbin 2000)
  9. Re: Unique SKU Numbers (Peter Ostry 2000)
  10. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  11. Re: Unique SKU Numbers (Clint Davis 2000)
  12. Re: Unique SKU Numbers (Derrick Puckett 2000)
  13. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  14. Re: Unique SKU Numbers (Glenn Busbin 2000)
  15. Re: Unique SKU Numbers (Nicolay Ramm 2000)
  16. Re: Unique SKU Numbers (Peter Ostry 2000)
  17. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  18. Unique SKU Numbers (Aaron Chute 2000)
I use this bit of code in an include. Everytime I need a unique number, I simply [include uniquenumber.incl] -- [lookup db=/db/unum.db&lookinfield=Ucode&value=Ucode&returnfield=Unumber¬found=wibble][replace db=/db/unum.db&equcodedatarq=Ucode]Unumber=[math][lookup db=/db/unum.db&lookinfield=ucode&value=Ucode&returnfield=Unumber]+1[/math][/replace] --This routine also requires a database with the highest used number: -- Ucode[TAB]Unumber Ucode [TAB]991092Simply seed the database with the first number you wish to use, and off you go.Good luck,D. On dinsdag, 21 maart 2000, Aaron Chute wrote: >How are most folks handling unique SKU numbers? Is there a canned >routine that will spin through SKU numbers - then increment by 1 - >and autofill a new record SKU field? > >TIA >Aaron > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Derrick Puckett

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:

database size? (1997) [OT] ISP Windows program (2005) Too Much Info (1998) wish list (2002) slowness (1998) TemplateCacheSize preference! (1998) ConvertChars (2000) WebDNA on OS X Tiger (2006) read and write you own cookies with webcat (1997) Perl programmer needed (2002) Fishing: anyone on this group willing to do support? (1998) Changing Date Format in Field (1999) RAM problems, [appendfile] problems (1998) emailer (1997) Admin User - Users.db (1999) Show if not working in version 4 (2002) Country & Ship-to address & other fields ? (1997) Help! WebCat2 bug (1997) Re[2]: Enhancement Request for WebCatalog-NT (1996) WebCatalog 2.0 b 15 mac (1997)