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 SteveI 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.--Govindagovinda.webdnatalk@gmail.com
Associated Messages, from the most recent to the oldest:
|
- Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Tom Duke 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & ("Terry Wilson" 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Govinda 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Steve Raslevich 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Dale Therio 2010)
- Re: [WebDNA] autonumber duplication, time stamp issue & locking up (Govinda 2010)
- [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 SteveI 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.--Govindagovinda.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:
Problem 2 of 2 (was: Shipping Confusion) (2000)
[cart] not being interpreted inside [founditems] (1997)
Re:Formulas.db / Quantity Discount problem (1998)
showif with math? (2000)
RE: type 2 errors with ssl server (1997)
What file? (1997)
New Install (2003)
why is authenticate screwing with me today (2002)
All choices on IE different than Netscape (1997)
html in a database (1998)
Anyone have an invoicing system? (1999)
Make sure I understand this??? (1997)
[ListFiles] context & alias (1997)
Summarising on two fields (1998)
[ShowIf] and empty fields (1997)
X etc.... (1999)
Banner DNA (1997)
[WebDNA] Grep (2009)
WebCat and PDF (2000)
OT: Heads-up to Smith Micro staff (2002)