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:PCS Customer submissions ? (1997)
Event Calendar (2004)
RE: Formulas.db + Users.db (1997)
Change to UPPERCASE (2000)
Search Criteria (2000)
Re[2]: Problem with new formvariables (2000)
Problems with [Search] param - Mac Plugin b15 (1997)
Encrypting the seed (2001)
customizing the color of user's pages (1997)
How many Databases can I open? (2003)
So many lookers, hey smith micro (2003)
Nested vs conditional (1997)
WebCatalog for Postcards ? (1997)
formulas.db ?? (1998)
[isfile] ? (1997)
Post arguments problem mac? (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Caching pages...again (2001)
webcat license???? (1997)
expired beta (1997)