Re: Updating Integer value in DB
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 68683
interpreted = N
texte = Ki Song wrote:> 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.Couple of other points to go with the good points that have been said.You *can* use "On_Hand" without the brackets as long it is a *math variable* and itis inside a math context. I am guessing you are grabbing this value from thedatabase *before* the replace context is used?.. so it depends on how you are initializingthe variable (math or text) weather you need the brackets.If I were you, once you get a replace context that you think should work, but doesn't.troubleshoot it by taking out the first and last brackets to see exactly what values are beinginput into the replace context:replace db=^inventory.db&eqSKUdatarq=[url][SKU][/url]]ON_HAND=[MATH]ON_HAND+[updatevalue][/MATH][/replaceLastly, along with what Matthew was talking about, "[math]" doesn't like to see blank values, and willbreak if that happens. A trick to getting around this, if you think there is a chance for a blank value,is to put a 0 before the questionable value/s..: ON_HAND=[math]0[ON_HAND]+0[updatevalue][/math]Donovan-- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Desktop Publishing, Print Consulting, Labels -> <-Glass Products, off-hand Classes/studio rental-> PH:> (608) 835-2476 | Forum:> http://egg.bz/forum/ Web Sites:> http://www.euca.us & http://www.egg.bz =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------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:
Ki Song wrote:> 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.Couple of other points to go with the good points that have been said.You *can* use "On_Hand" without the brackets as long it is a *math variable* and itis inside a math context. I am guessing you are grabbing this value from thedatabase *before* the replace context is used?.. so it depends on how you are initializingthe variable (math or text) weather you need the brackets.If I were you, once you get a replace context that you think should work, but doesn't.troubleshoot it by taking out the first and last brackets to see exactly what values are beinginput into the replace context:replace db=^inventory.db&eqSKUdatarq=[url][SKU][/url]]ON_HAND=[math]ON_HAND+[updatevalue][/MATH][/replaceLastly, along with what Matthew was talking about, "[math]" doesn't like to see blank values, and willbreak if that happens. A trick to getting around this, if you think there is a chance for a blank value,is to put a 0 before the questionable value/s..: ON_HAND=[math]0[ON_HAND]+0[updatevalue][/math]Donovan-- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Desktop Publishing, Print Consulting, Labels -> <-Glass Products, off-hand Classes/studio rental-> PH:> (608) 835-2476 | Forum:> http://egg.bz/forum/ Web Sites:> http://www.euca.us & http://www.egg.bz =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o-------------------------------------------------------------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/
Donovan Brooke
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:
WebCat2 - Getting to the browser's username/password data (1997)
Keep away (1997)
PSC recommends what date format yr 2000??? (1997)
Number searching/formats (1998)
WebCatalog for guestbook ? (1997)
DataBaseHelper Flawed (1997)
RE: Missing contexts on NT (1997)
OT: WebDNA and LINUX (2004)
OT. Self explanatory (2003)
We are searching (2005)
date formatting for CC card expiration date check (1998)
iTools WebDNA module keeps crashing (2006)
WebCat2 - [include] tags (1997)
Running webcat 6 on Windows XP Prof. (2005)
need some help with tcpsend (2000)
Database Advice (1996)
Assigning new CART number (1997)
Translation Considerations with DNA (2005)
customer info (2001)
[lineitems] Loop Break (2004)