Re: Likelihood of a duplicate

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 62218
interpreted = N
texte = Autonumber was introduced in v.5 I think. If you don't mind a little bit of a hit on your DB performance, you could use this old technique to manually increase your ID field: [text]newID=1[/text] [search db=my.db&neIDdatarq=find_all&deIDsort=1&IDtype=num&max=1] [founditems] [text]newID=[math][ID]+1[/math][/text] [/founditems] [/search] [replace db=my.db&eqIDdatarq=[newID]&append=T]ID=[newID][/replace] On 6/14/05 2:23 PM, "Gary Krockover" wrote: > What version was autonumber introduced? I have some sites on legacy v4.5, > and thus have to manually autonumber in those cases. I believe autonumber > was introduced in later versions. :( > > GJK > > At 02:00 PM 6/14/2005, you wrote: >> An even easier, and dare I say fool-proof, method would be to use autonumber >> with your append context as such: >> [append db=my.db&autonumber=ID]your stuff here[/append] ------------------------------------------------------------- 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:

    
  1. Re: Likelihood of a duplicate (Palle you around?) ( "Dan Strong" 2005)
  2. Re: Likelihood of a duplicate (Palle you around?) ( "WebDna @ Inkblot Media" 2005)
  3. Re: Likelihood of a duplicate (Palle you around?) ( "Dan Strong" 2005)
  4. Re: Likelihood of a duplicate (Palle you around?) ( "Palle B. Nielsen (PowerPalle)" 2005)
  5. Re: Likelihood of a duplicate (Palle you around?) ( "Dan Strong" 2005)
  6. Re: Likelihood of a duplicate ( "Dan Strong" 2005)
  7. Re: Likelihood of a duplicate ( Terry Wilson 2005)
  8. Re: Likelihood of a duplicate ( "Dan Strong" 2005)
  9. Re: Likelihood of a duplicate ( "Dan Strong" 2005)
  10. Re: Likelihood of a duplicate ( John Peacock 2005)
  11. Re: Likelihood of a duplicate ( Lester 2005)
  12. Re: Likelihood of a duplicate ( "Dan Strong" 2005)
  13. Re: Likelihood of a duplicate ( Donovan Brooke 2005)
  14. Re: Likelihood of a duplicate ( Donovan Brooke 2005)
  15. Re: Likelihood of a duplicate ( "Dan Strong" 2005)
  16. Re: Likelihood of a duplicate ( Gary Krockover 2005)
  17. Re: Likelihood of a duplicate ( John Peacock 2005)
  18. Re: Likelihood of a duplicate ( Clint Davis 2005)
  19. Re: Likelihood of a duplicate ( Gary Krockover 2005)
  20. Re: Likelihood of a duplicate ( "Dan Strong" 2005)
  21. Re: Likelihood of a duplicate ( Clint Davis 2005)
  22. Re: Likelihood of a duplicate ( Gary Krockover 2005)
  23. Re: Likelihood of a duplicate ( Bob Minor 2005)
  24. Likelihood of a duplicate ( Lester 2005)
Autonumber was introduced in v.5 I think. If you don't mind a little bit of a hit on your DB performance, you could use this old technique to manually increase your ID field: [text]newID=1[/text] [search db=my.db&neIDdatarq=find_all&deIDsort=1&IDtype=num&max=1] [founditems] [text]newID=[math][ID]+1[/math][/text] [/founditems] [/search] [replace db=my.db&eqIDdatarq=[newID]&append=T]ID=[newID][/replace] On 6/14/05 2:23 PM, "Gary Krockover" wrote: > What version was autonumber introduced? I have some sites on legacy v4.5, > and thus have to manually autonumber in those cases. I believe autonumber > was introduced in later versions. :( > > GJK > > At 02:00 PM 6/14/2005, you wrote: >> An even easier, and dare I say fool-proof, method would be to use autonumber >> with your append context as such: >> [append db=my.db&autonumber=ID]your stuff here[/append] ------------------------------------------------------------- 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/ Clint Davis

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:

Sort Order on a page search (1997) ShowIf Question (1998) Using [Include] Context (1999) Next (1997) Not Authorized (2000) [WebDNA] new list (2008) Search in 2 or more catalogs (1997) WebCommerce: Folder organization ? (1997) Emailer Chokes on bad address (1997) why is this line in GeneralStore? (1998) More on the email templates (1997) [WebDNA] naming math vars in v.7 (2010) setting taxable to true (1997) emailer (1997) [listfiles] (2004) shipcost (1997) Email within tmpl ? (1997) E-mail formating question (1999) [WebDNA] Help with WebDNA 7 Install on OS X Lion Server (2011) [WebDNA] Encode cookies ONLY via "method=Base64" (2008)