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:

[ShowCart]-- was ThankYou page problems (1997) Search syntax question (1998) Claris HomePage messes up the code (1997) Null Chars (1999) [WebDNA] Why doesn't this returnraw redirect to the new page? (2009) Silence before the storm? (2004) Searching multiple dbs (1998) RE: Displaying Location (1997) Fun with dates (1997) RE: CloseDatabase (1997) text conversions (1999) Old Style vs XML Syntax (2003) PIXO support (1997) Need relative path explanation (1997) Still having math problems (1997) [WebDNA] Code Library (2013) WebCat2 beta 11 - new prefs ... (1997) Error Lob.db records error message not name (1997) Formatting time output (2000) Re[2]: 2nd WebCatalog2 Feature Request (1996)