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 an append. I tried it. I ended up using [cart]. You may want to try creating a number database, 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:

    
  1. Re: Database Locking?!? (Smith Micro Support 2000)
  2. Re: Database Locking?!? ( 2000)
  3. Database Locking?!? (Howard Wolosky 2000)
  4. Re: Database Locking?!? (Conley Hanson 2000)
Hi, You will still have the possibility of repeating ID's even if you put it inside an append. I tried it. I ended up using [cart]. You may want to try creating a number database, 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)