Re: [WebDNA] autonumber duplication, time stamp issue & locking up

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 105441
interpreted = N
texte = > #1) In this short time, the [autonumber] function created at least > (2) identical, yet uniquely autonumbered records for (2) different > customer submits. Both duplicate entries show a unique autonumber 1 > apart from each other and show a time stamp of exactly the same time > down to the second. The user clicking the submit button more than > once should not be the issue here. I have the contest limited to one > entrant per email address per month. When the form is submitted, it > first searches the contest.db file for an existing record generated > this month that contains the same email address being submitted. > WebDNA should have found the first record and not written the second > record due to the email address match but it did so twice. The time > between the two occurrences is roughly 3 hours. Hi Steve I dunno, ...but regarding your first paragraph... pehaps you could try a workaround for [autnumber] by using code like what is found at the bottom (User Contributed Notes - See Gary's), from here: http://docs.webdna.us/pages.html?context=ReplaceContext.html ...just a thought. I never use [autonumber] so I can't say. In the past we have always used [cart] (or even sometimes [cart]_[index] , when inside a loop) to generate a unique ID for a field val. I have seen code like Gary's example working fine.. but not under a heavy-simultaneous-use environment. But it may be safer than [autonumber] (?).. by the sound of things that you are finding. -- Govinda govinda.webdnatalk@gmail.com Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Tom Duke 2010)
  2. Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
  3. Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
  4. Re: [WebDNA] autonumber duplication, time stamp issue & ("Terry Wilson" 2010)
  5. Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Govinda 2010)
  6. Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
  7. Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
  8. Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Dale Therio 2010)
  9. Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Govinda 2010)
  10. [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
> #1) In this short time, the [autonumber] function created at least > (2) identical, yet uniquely autonumbered records for (2) different > customer submits. Both duplicate entries show a unique autonumber 1 > apart from each other and show a time stamp of exactly the same time > down to the second. The user clicking the submit button more than > once should not be the issue here. I have the contest limited to one > entrant per email address per month. When the form is submitted, it > first searches the contest.db file for an existing record generated > this month that contains the same email address being submitted. > WebDNA should have found the first record and not written the second > record due to the email address match but it did so twice. The time > between the two occurrences is roughly 3 hours. Hi Steve I dunno, ...but regarding your first paragraph... pehaps you could try a workaround for [autnumber] by using code like what is found at the bottom (User Contributed Notes - See Gary's), from here: http://docs.webdna.us/pages.html?context=ReplaceContext.html ...just a thought. I never use [autonumber] so I can't say. In the past we have always used [cart] (or even sometimes [cart]_[index] , when inside a loop) to generate a unique ID for a field val. I have seen code like Gary's example working fine.. but not under a heavy-simultaneous-use environment. But it may be safer than [autonumber] (?).. by the sound of things that you are finding. -- Govinda govinda.webdnatalk@gmail.com Govinda

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:

Big Databases (1997) Setting up shop (1997) [OT] Theiving B*****ds (2004) Webcat 2.0.1 date math bug -> Crash! (1997) Single Link browsing (1997) taxrate - off by 1 cent (1997) Email notification to one of multiple vendors ? (1997) shownext (1997) 2nd WebCatalog2 Feature Request (1996) [WebDNA] help with [ReturnRaw] - why is it killing the (2009) Running _every_ page through WebCat ? (1997) search engines (2001) HTML Editors (1997) Error -108 (1997) WebCommerce: Folder organization ? (1997) [WebDNA] PCI Vulnerability testing (2009) 9 digit zip (2002) help needed: Non-english characters in WebCatalog (1997) Firesite and WebCat (1999) Signal Raised (1997)