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:
RE: Webcatalog and CyberSTUD (1998)
Database Advice (1996)
service stop and restart (1997)
WebMerchant 1.6 and https (1997)
bye bye tax rate (1998)
Encrypted links ... (2000)
Paths (1998)
Was 5.0 Pricing, now Sandbox versus Website and ruminating (2003)
[WebDNA] Installing 6.0 onto Server 2008 (2011)
MasterCounter and capitalization (1997)
Sorting Number with commas (2001)
Sense/Disallow HTML tags during $Append (1997)
OFF-TOPIC: Check www.godaddy.com for me ... (2003)
url question (2002)
RE: New WebCatalog Version !!! (1997)
Max Record length restated as maybe bug (1997)
Help name our technology! (1997)
MATH TIME (1997)
WebDNA won't start on reboot (2003)
random .inc files pulled and placed (2002)