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:
Database Helper Update (1998)
Ok here is a question? (1997)
Beta Documentation (1997)
[date format] w/in sendmail (1997)
Secure Server (1997)
Re:PCS Customer submissions ? (1997)
Online docs errata (2000)
Surprise x and y post args (1998)
Sorting by date (1997)
[addlineitems] as oppossed to url command=add (2000)
Re:my First Ship table (1998)
Netscape v. IE (1997)
mass mailing (1998)
vars (2000)
Email within tmpl ? (1997)
item sorting (1997)
page redirect in webDNA (1997)
URGENT! ACGI Stopped!!!! (1997)
user/password validation (1998)
problems with 2 tags shakur (1997)