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]UnumberUcode [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:
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]UnumberUcode [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)