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 multiple includes 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=2Ecom To: WebDNA-Talk@talk=2Esmithmicro=2Ecom Subject: RE: Same DB Same Time Date: 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=20 else 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:

    
  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)
Does it have to be in an iframe=3F Couldn't you just do multiple includes 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=2Ecom To: WebDNA-Talk@talk=2Esmithmicro=2Ecom Subject: RE: Same DB Same Time Date: 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=20 else 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!

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:

OT: Google (2002) Problems with [Applescript] (1997) Error handling for accountNum (1997) Virtual hosting and webcatNT (1997) WebCat2 - [include] tags (1997) Credit card types (1997) WebCatalog (1998) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) multiple search commands (1997) Webcat & SIMS (1998) Pipes instead of tabs (1998) Smart caching problems with 2.1b3? (1997) [showif] based on data from [tcpconnect][tcpsend]? (2000) when is date system date or order date? (1997) Too Much Rootbeer Free Offer (1997) Re:Emailer and encryption (1997) [writefile] and CR's (2001) Almost a there but..bye bye NetCloak (1997) Extended [ConvertChars] (1997) WebCat2: multiple currency support (1997)