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][Searchdb=shop_customers.db&neticketdatarq=[blank]&deticketsort=1&tickettype=num&max=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:
Re: Auto-increment number, but only up to 100 then start overat 1 (Alain Russell 2002)
Something like .. [text]newTICKET=[math][Searchdb=shop_customers.db&neticketdatarq=[blank]&deticketsort=1&tickettype=num&max=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
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...