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:
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)