Re: Sequential Code Logic
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 53993
interpreted = N
texte = Might be able to give you a little start Clint. I had built a ticketing system where they numbered their tickets sequentially from 1-99, rolling over to 1 again. When drawing the next ticket number, I added this to the append: [GetChars start=1&end=2&from=end][math]NewTICKET=([Search db=shop_customers.db&neskudatarq=[blank]&deskusort=1&skutype=num&max=1][FoundItems][sku][/FoundItems][/Search]+1)[/math][/GetChars] Apply that to a "ticker" that checks this value and applies a math +1 to field 4 and I think you'd have a good start. GK At 08:58 AM 11/12/2003, you wrote: >A store I'm building will be selling an item that is serialized with a >sequential code like this: > >1 1 A 1 1 >1 1 A 1 2 >... >1 1 A 1 99 >1 1 A 2 1 >... >1 1 A 99 99 >1 1 B 1 1 >... >1 1 D 99 99 >1 2 A 1 1 >... >1 99 D 99 99 >2 1 A 1 1 > > >Field 1 = 1-99 >Field 2 = 1-99 >Field 3 = A-D >Field 4 = 1-99 >Field 5 = 1-99 > > >When field 5 reaches 99, it rolls over to 1 and field 4 bumps up one digit >and so on. > >Does anyone have code or logic that might help with this? ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Might be able to give you a little start Clint. I had built a ticketing system where they numbered their tickets sequentially from 1-99, rolling over to 1 again. When drawing the next ticket number, I added this to the append: [GetChars start=1&end=2&from=end][math]NewTICKET=([Search db=shop_customers.db&neskudatarq=[blank]&deskusort=1&skutype=num&max=1][founditems][sku][/FoundItems][/Search]+1)[/math][/GetChars] Apply that to a "ticker" that checks this value and applies a math +1 to field 4 and I think you'd have a good start. GK At 08:58 AM 11/12/2003, you wrote: >A store I'm building will be selling an item that is serialized with a >sequential code like this: > >1 1 A 1 1 >1 1 A 1 2 >... >1 1 A 1 99 >1 1 A 2 1 >... >1 1 A 99 99 >1 1 B 1 1 >... >1 1 D 99 99 >1 2 A 1 1 >... >1 99 D 99 99 >2 1 A 1 1 > > >Field 1 = 1-99 >Field 2 = 1-99 >Field 3 = A-D >Field 4 = 1-99 >Field 5 = 1-99 > > >When field 5 reaches 99, it rolls over to 1 and field 4 bumps up one digit >and so on. > >Does anyone have code or logic that might help with this? ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Gary Krockover
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:
[countWords]? (1997)
Paranoid about serial numbers...not (1998)
Re:Has this happened to you? (1997)
WebMerchant? (1998)
Help formatting search results w/ table (1997)
Setting up WebCatalog with Retail Pro data (1996)
Fwd: Problems with Webcatalog Plug-in (1997)
Micro-managing External Links (2006)
Quit revisited (1997)
Secure Server basic question... (1997)
WebCatalog NT beta 18 now available (1997)
Referrer field to header field conversion (1997)
For those of you not on the WebCatalog Beta... (1997)
SMSI - MacWorld (2005)
forming a SKU (1999)
Notepad problems - SOLVED! (1998)
Errant Email. (1998)
OUTSIDE LINKS TO SHOW SHOPPING CART????????? (1998)
Emailer setup (1997)
Nested Lookups (1998)