Updating Integer value in DB

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 68677
interpreted = N
texte = Really quick question. I am trying to create a call to a products.db to update a quantity on an inventory item so that, for example, if the value that is in the db currently is 2, and I wanted to add 1 to the quantity, how would I accomplish this? I wrote the following replace command, but it doesn't seem to work: [replace db=^inventory.db&wqSKUdatarq=[SKU]]ON HAND=[MATH]ON HAND+[updatevalue][/MATH][/replace] updatevalue = an integer, positive or negative, that is used to change the ON HAND. For example: SKU= test ON HAND= 3 updatevalue= 45 After this replace is done, ON HAND should = 48. ------------------------------------------------------------- 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: Updating Integer value in DB ( Stuart Tremain 2007)
  2. Re: Updating Integer value in DB ( Matthew A Perosi 2007)
  3. Re: Updating Integer value in DB ( Donovan Brooke 2007)
  4. Re: Updating Integer value in DB ( "Dan Strong" 2007)
  5. Re: Updating Integer value in DB ( Matthew A Perosi 2007)
  6. Re: Updating Integer value in DB ( Ki Song 2007)
  7. Re: Updating Integer value in DB ( Jim Ziegler 2007)
  8. Re: Updating Integer value in DB ( Matthew A Perosi 2007)
  9. Updating Integer value in DB ( Ki Song 2007)
Really quick question. I am trying to create a call to a products.db to update a quantity on an inventory item so that, for example, if the value that is in the db currently is 2, and I wanted to add 1 to the quantity, how would I accomplish this? I wrote the following replace command, but it doesn't seem to work: [replace db=^inventory.db&wqSKUdatarq=[SKU]]ON HAND=[math]ON HAND+[updatevalue][/MATH][/replace] updatevalue = an integer, positive or negative, that is used to change the ON HAND. For example: SKU= test ON HAND= 3 updatevalue= 45 After this replace is done, ON HAND should = 48. ------------------------------------------------------------- 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/ Ki Song

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:

[input] [/input] (1997) WebCat2b13MacPlugin - nested [xxx] contexts (1997) Multiple prices (1997) UPS online (2003) One other big addition... (1997) Re:Emailer and encryption (1997) Re:What file? (1997) Storebuilder/Webmerchant and Manual CC Processing (2001) & Aftermath (1999) WebCat2 - Getting to the browser's username/password data (1997) I can help! (1996) Reload of the shoppingcart.tmpl page (1999) Refering page (1998) [date] formatting bug inside [orderfile]? (1998) ups quickcost [repost] (1999) Projects & Contractors (1997) SUBMIT buttons not working.... (2000) RE: Migrating to NT (1997) emailer (1997) [math] storage of variables (1997)