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 = 40755
interpreted = N
texte = Something like .. [text]newTICKET=[math][Search db=shop_customers.db&neticketdatarq=[blank]&deticketsort=1&tickettype=num&ma x=1][FoundItems][ticket][/FoundItems][/Search]+1[/math][/text][showif [newTicket]>100]newticket=1[/text][newticket]Alain> 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&ma > 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 > > > ------------------------------------------------------------- > 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)
Something like .. [text]newTICKET=[math][Search db=shop_customers.db&neticketdatarq=[blank]&deticketsort=1&tickettype=num&ma x=1][founditems][ticket][/FoundItems][/Search]+1[/math][/text][showif [newTicket]>100]newticket=1[/text][newticket]Alain> 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&ma > 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 > > > ------------------------------------------------------------- > 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/ Alain Russell

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:

The Guru Speaks-very long reply (1998) [browsername] not working? (1997) webcat feature request (1997) [WriteFile] problems (1997) Timeout question .. (2003) tcpconnect feature request .. (2003) sorting and grouping (1998) Wanted: More Math Functions (or, Can You Solve This?) (1997) Thanks and new Question on lineitems (2002) Using Currencies other than Dollars (1997) Dropdown menus (2006) japanese characters (1997) Need a Calendar System (2001) webDNA and ASP pages (1997) Date search - yes or no (1997) Non HTML file protection - OS X (webstar or apache) (2002) set header in DB (no cart) (2003) WebCat2b12 CGI Mac - [shownext] problem (1997) WebCat2: Items xx to xx shown, etc. (1997) Spamming this list! (2000)