Re: Auto-increment number, but only up to 100 then start overat 1

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 40758
interpreted = N
texte = Yes, that's probably the best idea. It's just a quick reference number to know which item is next in line for service. Numbers with several digits could get confusing for some I'm supposing, so yeah, hide all but the last 2 digits. Duh.Thanks! GK > What if you actually auto-incremented to eternity, and only ever > display the last 2 digits, with appropriate manipulation to show 04 > as 4 and 00 as 100? > > - brian > > At 5:10 PM 6/20/02, Gary Krockover wrote: > >Hey all, > > > >Client has a system where work order tickets are numbered in the order > >received from 1-100, then it starts over again at 1. I'd like to have this > >electronic version of their work order auto-increment that ticket number > >(ticket) for them based on what the last ticket number was. > > > >I can do the auto increment based off of a suggestion made to me before: > > >db=shop_customers.db&neticketdatarq=[blank]&deticketsort=1&tickettype=num&m a > >x=1][FoundItems][ticket][/FoundItems][/Search]+1)[/math]> > > > >But can't figure out what combination of showif's/hideif's I need in there > >to have it start over again at 1 after 100 is reached. Any ideas? Maybe > >get the last ticket from the most recent via [date] & [time]? > > > >There obviously will be (eventually) muliple instances of this field > >(ticket) and no, it is not my key field (unique). > > > >Thanks! > >GK > > -- > <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com => > <= Macintosh, Internet and Multimedia http://www.artsofauburn.com => > <= Development and Consulting => > > ------------------------------------------------------------- > 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://search.smithmicro.com/ ------------------------------------------------------------- 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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Auto-increment number, but only up to 100 then start overat 1 (Gary Krockover 2002)
  2. Re: Auto-increment number, but only up to 100 then start overat 1 (Brian Fries 2002)
  3. Re: Auto-increment number, but only up to 100 then start overat 1 (Alain Russell 2002)
  4. Re: Auto-increment number, but only up to 100 then start overat 1 (Alain Russell 2002)
Yes, that's probably the best idea. It's just a quick reference number to know which item is next in line for service. Numbers with several digits could get confusing for some I'm supposing, so yeah, hide all but the last 2 digits. Duh.Thanks! GK > What if you actually auto-incremented to eternity, and only ever > display the last 2 digits, with appropriate manipulation to show 04 > as 4 and 00 as 100? > > - brian > > At 5:10 PM 6/20/02, Gary Krockover wrote: > >Hey all, > > > >Client has a system where work order tickets are numbered in the order > >received from 1-100, then it starts over again at 1. I'd like to have this > >electronic version of their work order auto-increment that ticket number > >(ticket) for them based on what the last ticket number was. > > > >I can do the auto increment based off of a suggestion made to me before: > >[math]NewTICKET=([Search > >db=shop_customers.db&neticketdatarq=[blank]&deticketsort=1&tickettype=num&m a > >x=1][founditems][ticket][/FoundItems][/Search]+1)[/math]> > > > >But can't figure out what combination of showif's/hideif's I need in there > >to have it start over again at 1 after 100 is reached. Any ideas? Maybe > >get the last ticket from the most recent via [date] & [time]? > > > >There obviously will be (eventually) muliple instances of this field > >(ticket) and no, it is not my key field (unique). > > > >Thanks! > >GK > > -- > <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com => > <= Macintosh, Internet and Multimedia http://www.artsofauburn.com => > <= Development and Consulting => > > ------------------------------------------------------------- > 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://search.smithmicro.com/ ------------------------------------------------------------- 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://search.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:

Converting spaces to + in results list (2000) [OT] Airport Network (2003) possible, WebCat2.0 and checkboxes-restated (1997) RE: Help name our technology! (1997) Plugin or CGI or both (1997) WCS Newbie question (1997) raw field names (2001) [OT] 'Email this story to a friend' (2003) How long until WebDNA makes the list? :( (2004) wrong input values? (1997) Problems deleting when a search field is blank... (1998) Saving Text Areas with Orders (1997) Re:Dashes and dots in credit card (1998) webcat (2000) Gettting IPAddress (2001) problems with 2 tags (1997) Occasional crashes with $remove (1997) Occasional crashes with $remove (1997) Initiating NewCart (1997) show me your store ! (2003)