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:
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)