Re: Database Locking?!?
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26110
interpreted = N
texte = Hi,You will still have the possibility of repeating ID's even if you put it inside anappend. I tried it. I ended up using [cart]. You may want to try creating a numberdatabase, where your IDs are drawn from. Once they are called they are marked used.Howard Wolosky wrote:> This has been discussed before and I'm bringing it up again...>> Database locking.> Let me make a few quick assumptions for my problem to prevent solutions> that I can't use:> 1. I MUST use my sequential number solution as the record ID.> 2. Refer to #1> 3. I can't really reduce the size of the database for other reasons.>> Based on the above assumptions, I do a search on a database in order to> determine the next sequential number, and then I append the record with> that new ID number, and all it's information (a lot of information).>> Unfortunately, it seems that this append takes so long (much less than a> second, but long enough to cause this problem), if another person hits the> page, they TOO will get that same ID since the new one wasn't appended to> the database before they hit that page. It's gotten to a point where I> actually can get 6 duplicate IDs, and that's just plain bad.>> My question is, I need to do database locking somehow. If I do my> search INSIDE of the append, will that lock access to the database until> the append completes, and therefore solve my duplicate ID problem?>> If not, any other ideas on this (but sticking to the top 3 assumptions)?>> Thanks. Appreciate any help on this one that I can get.>> -Howard>> -------------------------------------------------------------> Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.> To end your Mail problems go to
.>> 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 -------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
Associated Messages, from the most recent to the oldest:
Hi,You will still have the possibility of repeating ID's even if you put it inside anappend. I tried it. I ended up using [cart]. You may want to try creating a numberdatabase, where your IDs are drawn from. Once they are called they are marked used.Howard Wolosky wrote:> This has been discussed before and I'm bringing it up again...>> Database locking.> Let me make a few quick assumptions for my problem to prevent solutions> that I can't use:> 1. I MUST use my sequential number solution as the record ID.> 2. Refer to #1> 3. I can't really reduce the size of the database for other reasons.>> Based on the above assumptions, I do a search on a database in order to> determine the next sequential number, and then I append the record with> that new ID number, and all it's information (a lot of information).>> Unfortunately, it seems that this append takes so long (much less than a> second, but long enough to cause this problem), if another person hits the> page, they TOO will get that same ID since the new one wasn't appended to> the database before they hit that page. It's gotten to a point where I> actually can get 6 duplicate IDs, and that's just plain bad.>> My question is, I need to do database locking somehow. If I do my> search INSIDE of the append, will that lock access to the database until> the append completes, and therefore solve my duplicate ID problem?>> If not, any other ideas on this (but sticking to the top 3 assumptions)?>> Thanks. Appreciate any help on this one that I can get.>> -Howard>> -------------------------------------------------------------> Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.> To end your Mail problems go to .>> 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 -------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
Conley Hanson
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:
[object] Tag & WebDNA Support (2005)
WebCat2.0 acgi vs plugin (1997)
Webcat/Webmerchant (1998)
BIG PROBLEMS with Checkboxes!!! (1998)
Non-Cart Files in Shopping Cart Folder (1997)
How to find 100 most recent additions. (1997)
[WebDNA] [OT] WebDNA Payment Processing Integration Recommendations? (2011)
[OT] help with a javascript alert (2003)
Poll Please (2002)
[showif] or-ing (1999)
Weird Math and SV (1997)
show all problem (1997)
supressing math results (1997)
WebCat2b13MacPlugIn - syntax to convert date (1997)
Max Record length restated as maybe bug (1997)
Paging a SQL result... (2003)
Frames and WebCat (1997)
Frames and WebCat (1997)
my price won't move (1997)
instant cookies? (1999)