Re: New Cart No. on same page

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47330
interpreted = N
texte = On 1/31/03 12:40 PM, Gary Krockover wrote:> A self incrementing sku? > > Someone provided this a while back to me and I've long had it in my snippets > list, hopefully it helps you: > > [math]Newsku=([Search > db=database.db&neskudatarq=[blank]&deskusort=1&skutype=num&max=1][FoundItems > ][sku][/FoundItems][/Search]+1)[/math]Just be careful with this in that there can only be one access to this 'at a time'.If this weren't carefully monitored, 2 identical skus could be written back to the db because of the delay from receiving and appending the db with the new incremented sku.Based on your application you may not have that problem but its worth mentioning. AlexAlex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer------------------------------------------------------------- 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: New Cart No. on same page (Matthew Bohne 2003)
  2. Re: New Cart No. on same page (Alex McCombie 2003)
  3. Re: New Cart No. on same page (Gary Krockover 2003)
  4. New Cart No. on same page (Matthew Bohne 2003)
On 1/31/03 12:40 PM, Gary Krockover wrote:> A self incrementing sku? > > Someone provided this a while back to me and I've long had it in my snippets > list, hopefully it helps you: > > [math]Newsku=([Search > db=database.db&neskudatarq=[blank]&deskusort=1&skutype=num&max=1][FoundItems > ][sku][/FoundItems][/Search]+1)[/math]Just be careful with this in that there can only be one access to this 'at a time'.If this weren't carefully monitored, 2 identical skus could be written back to the db because of the delay from receiving and appending the db with the new incremented sku.Based on your application you may not have that problem but its worth mentioning. AlexAlex J McCombie New World Media Chief Information Officer Drawer 607 800/724.8973 Fair Haven, NY 13064 Alex@NewWorldMedia.com http://OurClients.comInterface Designer WebDNA Programmer Database Designer------------------------------------------------------------- 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/ Alex McCombie

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:

Multiple Pulldowns (1997) Installing WebCat under Linux Q (2000) The max=0 issue is a bug ... CALL TO ACTION (2000) Help! WebCat2 bug (1997) OS X, Communigate Pro & Line Breaks (2003) SiteGuard Admin Feature ? (1997) WebDelivery: One step closer !! (1997) Limitations on fields? Server is crashing (1997) 2.1 bugs left over from beta cycle (1998) Nesting WebDNA in JavaScript (2003) searchable list archive (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) WC2b15 File Corruption (1997) WebCat2_Mac RETURNs in .db (1997) WebCatalog/Mac 2.1b2 New Features (1997) There's a bug in the math context ... (1997) rename a file (1997) New Website with Redakto CMS (2003) Sorting by date (1997) Itools, WEBCAT OSX (2003)