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 toupdate a quantity on an inventory item so that, for example, if the valuethat is in the db currently is 2, and I wanted to add 1 to the quantity, howwould 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]ONHAND+[updatevalue][/MATH][/replace]updatevalue = an integer, positive or negative, that is used to change theON HAND.For example:SKU= testON HAND= 3updatevalue= 45After 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:
Really quick question. I am trying to create a call to a products.db toupdate a quantity on an inventory item so that, for example, if the valuethat is in the db currently is 2, and I wanted to add 1 to the quantity, howwould 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]ONHAND+[updatevalue][/MATH][/replace]updatevalue = an integer, positive or negative, that is used to change theON HAND.For example:SKU= testON HAND= 3updatevalue= 45After 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)