Same DB Same Time

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55948
interpreted = N
texte = I have two iFrames on a page. Both of the iFrame's src is the same. It = is a .tpl page that does a [replacefounditems] on one database and an [= append] on another database. The [replacefounditems] pulls an integer from the database, increases it = by one, and then replaces the old value. The [append] creates a new sku = by grabbing the highest integer and increasing it by one (basically an = autonumber). Sometimes this all works just fine with the same .tpl firing at the same = time, accessing the same db at the same time and updating at the same time;= however, sometimes it does not. In the case that it does not, I get = duplicate skus and the integer that is supposed to be updated by the [= replacefounditems] does not update. I've tested this numerous times (a lot). It acts like the two statements = fire and collide with each other. Or that one isn't commiting in time for = the other statement to realize anything has changed in the database. It = seems like WebDNA should have some sort of buffer for accessing the same = database at the same time. I've wrote the talk list about this problem before and haven't come up = with any great solution. I'd like to give this another whirl and see if = we can't find something. Please help. Thanks. Justin Carroll ------------------------------------------------------------- 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: Same DB Same Time ( Justin Carroll 2004)
  2. Re: Same DB Same Time ( "Matthew C. Bohne" 2004)
  3. Re: Same DB Same Time ( Gary Krockover 2004)
  4. Re: Same DB Same Time ( Dylan Wood 2004)
  5. Re: Same DB Same Time ( Alex McCombie 2004)
  6. Re: Same DB Same Time ( John Peacock 2004)
  7. Re: Same DB Same Time ( John Peacock 2004)
  8. Re: Same DB Same Time ( "Dan Strong" 2004)
  9. Re: Same DB Same Time ( Alex McCombie 2004)
  10. Re: Same DB Same Time ( Justin Carroll 2004)
  11. Re: Same DB Same Time ( Grant Hulbert 2004)
  12. Re: Same DB Same Time ( John Peacock 2004)
  13. Re: Same DB Same Time ( Alex McCombie 2004)
  14. Same DB Same Time ( Justin Carroll 2004)
I have two iFrames on a page. Both of the iFrame's src is the same. It = is a .tpl page that does a [replacefounditems] on one database and an [= append] on another database. The [replacefounditems] pulls an integer from the database, increases it = by one, and then replaces the old value. The [append] creates a new sku = by grabbing the highest integer and increasing it by one (basically an = autonumber). Sometimes this all works just fine with the same .tpl firing at the same = time, accessing the same db at the same time and updating at the same time;= however, sometimes it does not. In the case that it does not, I get = duplicate skus and the integer that is supposed to be updated by the [= replacefounditems] does not update. I've tested this numerous times (a lot). It acts like the two statements = fire and collide with each other. Or that one isn't commiting in time for = the other statement to realize anything has changed in the database. It = seems like WebDNA should have some sort of buffer for accessing the same = database at the same time. I've wrote the Talk List about this problem before and haven't come up = with any great solution. I'd like to give this another whirl and see if = we can't find something. Please help. Thanks. Justin Carroll ------------------------------------------------------------- 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/ Justin Carroll

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:

Opinion: [input] should be called [output] ... (1997) Snake Bites (1997) Bug Report in the docs or? Listfields WebDNA 4.5 (2002) [LOOKUP] (1997) WebCatalog can't find database (1997) a little OT (2001) ADD a product without Database (1998) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Meet your competition (2000) Initiating NewCart (1997) dos performance (1998) 4.0 send email ticks. . (2000) Emailer setup (1997) URGENT - CPU usage OSXS (2001) Append File help needed (2000) Bug Report, maybe (1997) unsubscribe (1997) Using WC for Bulk Emailings (1997) Supressing Error Messages (1998) Error handling for accountNum (1997)