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:

Car Database (2002) cart info (1998) Sherlock plug-in? (1999) WebCat on 10.0.4 - iTools 6.0 (2001) Shopping Cart ID (1998) nslookup (2000) WebCat2: Items xx to xx shown, etc. (1997) Repeating Fields (1997) Range Comparisons (2000) database size? (1997) Mac Scheduling (1998) [showif]'s inside [search] params? (2000) Almost a there but..bye bye NetCloak (1997) Adding up line items. (2000) Shopping cart now good (fixed it) (1997) read and write you own cookies with webcat (1997) Error (1997) Re:E-mailer application times out (1998) Admin Edit prob. (1997) Question about [encrypt] (1998)