Re: Same DB Same Time

This WebDNA talk-list message is from

2004

It keeps the original formatting. numero = 55965
interpreted = N
texte = Does it have to be in an iframe=3F Couldn't you just do multipleincludes of the same file, changing variables as needed=3F[text show=3Df]section=3D1[/text][text show=3Df]banner=5Fwidth=3D468[/text][text show=3Df]banner=5Fheight=3D60[/text][include banners=2Einc][text show=3Df]section=3D2[/text][text show=3Df]banner=5Fwidth=3D117[/text][text show=3Df]banner=5Fheight=3D240[/text][include banners=2Einc]---- Original Message ----From: justincarroll@sanduskyregister=2EcomTo: WebDNA-Talk@talk=2Esmithmicro=2EcomSubject: RE: Same DB Same TimeDate: 09 Feb 2004 11:57:14 -0500>I have two iFrames on a page=2E Both of the iFrame's src is the same=2E=20=>It is a =2Etpl page that does a [replacefounditems] on one database and>an [append] on another database=2E>>The [replacefounditems] pulls an integer from the database, increases>it by one, and then replaces the old value=2E The [append] creates a>new sku by grabbing the highest integer and increasing it by one>(basically an autonumber)=2E>>Sometimes this all works just fine with the same =2Etpl firing at the>same time, accessing the same db at the same time and updating at the>same time; however, sometimes it does not=2E 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=2E>>I've tested this numerous times (a lot)=2E It acts like the two>statements fire and collide with each other=2E Or that one isn't>commiting in time for the other statement to realize anything has>changed in the database=2E It seems like WebDNA should have some sort>of buffer for accessing the same database at the same time=2E>>I've wrote the talk list about this problem before and haven't come>up with any great solution=2E I'd like to give this another whirl and>see if we can't find something=2E Please help=2E Thanks=2E>>Justin Carroll>>>>------------------------------------------------------------->This message is sent to you because you are subscribed to> the mailing list =2E>To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to>>Web Archive of this list is at: http://webdna=2Esmithmicro=2Ecom/----"I've never known a musician who regretted being one=2E Whatever=20else life gives you, music will never let you down=2E-------------------------------------------------------------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:

Re: Same DB Same Time ( Justin Carroll 2004)
Re: Same DB Same Time ( "Matthew C. Bohne" 2004)
Re: Same DB Same Time ( Gary Krockover 2004)
Re: Same DB Same Time ( Dylan Wood 2004)
Re: Same DB Same Time ( Alex McCombie 2004)
Re: Same DB Same Time ( John Peacock 2004)
Re: Same DB Same Time ( John Peacock 2004)
Re: Same DB Same Time ( "Dan Strong" 2004)
Re: Same DB Same Time ( Alex McCombie 2004)
Re: Same DB Same Time ( Justin Carroll 2004)
Re: Same DB Same Time ( Grant Hulbert 2004)
Re: Same DB Same Time ( John Peacock 2004)
Re: Same DB Same Time ( Alex McCombie 2004)
Same DB Same Time ( Justin Carroll 2004)

Does it have to be in an iframe=3F Couldn't you just do multipleincludes of the same file, changing variables as needed=3F[text show=3Df]section=3D1[/text][text show=3Df]banner=5Fwidth=3D468[/text][text show=3Df]banner=5Fheight=3D60[/text][include banners=2Einc][text show=3Df]section=3D2[/text][text show=3Df]banner=5Fwidth=3D117[/text][text show=3Df]banner=5Fheight=3D240[/text][include banners=2Einc]---- Original Message ----From: justincarroll@sanduskyregister=2EcomTo: WebDNA-Talk@talk=2Esmithmicro=2EcomSubject: RE: Same DB Same TimeDate: 09 Feb 2004 11:57:14 -0500>I have two iFrames on a page=2E Both of the iFrame's src is the same=2E=20=>It is a =2Etpl page that does a [replacefounditems] on one database and>an [append] on another database=2E>>The [replacefounditems] pulls an integer from the database, increases>it by one, and then replaces the old value=2E The [append] creates a>new sku by grabbing the highest integer and increasing it by one>(basically an autonumber)=2E>>Sometimes this all works just fine with the same =2Etpl firing at the>same time, accessing the same db at the same time and updating at the>same time; however, sometimes it does not=2E 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=2E>>I've tested this numerous times (a lot)=2E It acts like the two>statements fire and collide with each other=2E Or that one isn't>commiting in time for the other statement to realize anything has>changed in the database=2E It seems like WebDNA should have some sort>of buffer for accessing the same database at the same time=2E>>I've wrote the Talk List about this problem before and haven't come>up with any great solution=2E I'd like to give this another whirl and>see if we can't find something=2E Please help=2E Thanks=2E>>Justin Carroll>>>>------------------------------------------------------------->This message is sent to you because you are subscribed to> the mailing list =2E>To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to>>Web Archive of this list is at: http://webdna=2Esmithmicro=2Ecom/----"I've never known a musician who regretted being one=2E Whatever=20else life gives you, music will never let you down=2E-------------------------------------------------------------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/ "Matthew C. Bohne"

DOWNLOAD WEBDNA NOW!

Re: Same DB Same Time

2004

Top Articles:

Related Readings: