Re: Updating Integer value in DB
This WebDNA talk-list message is from 2007
It keeps the original formatting.
numero = 68680
interpreted = N
texte = > From: Matthew A Perosi
> Reply-To: "WebDNA Talk" > Date: Wed, 14 Mar 2007 12:34:10 -0400> To: "WebDNA Talk" > Subject: Re: Updating Integer value in DB> > I used to run into a lot of problems with database fields with spaces in> them. i.e. "ON HAND" instead of the more reliable "ON_HAND". I've> gotten them to work, but not without [url]ing everything.> > That said, I see 2 errors in your code so try this:> You have a typo of "wqSKUdatarq" instead of "eqSKUdatarq"> And the variable ON_HAND needs to be stated as a variable in [] inside> the [math] context.> > [replace > db=^inventory.db&eqSKUdatarq=[SKU]]ON_HAND=[MATH][ON_HAND]+[updatevalue][/MATH> ][/replace]> The wq was a typo on the email, not the actual code.I did that, but it does not update.Do you think the ON HAND, as opposed to an ON_HAND, may be the problem?-------------------------------------------------------------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:
> From: Matthew A Perosi > Reply-To: "WebDNA Talk" > Date: Wed, 14 Mar 2007 12:34:10 -0400> To: "WebDNA Talk" > Subject: Re: Updating Integer value in DB> > I used to run into a lot of problems with database fields with spaces in> them. i.e. "ON HAND" instead of the more reliable "ON_HAND". I've> gotten them to work, but not without [url]ing everything.> > That said, I see 2 errors in your code so try this:> You have a typo of "wqSKUdatarq" instead of "eqSKUdatarq"> And the variable ON_HAND needs to be stated as a variable in [] inside> the [math] context.> > [replace > db=^inventory.db&eqSKUdatarq=[SKU]]ON_HAND=[math][ON_HAND]+[updatevalue][/MATH> ][/replace]> The wq was a typo on the email, not the actual code.I did that, but it does not update.Do you think the ON HAND, as opposed to an ON_HAND, may be the problem?-------------------------------------------------------------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:
[WriteFile] problems (1997)
'does not contain' operator needed ... (1997)
PCS Frames (1997)
WebCat2 - storing unformatted date data? (1997)
[WebDNA] Mass email using WebDNA (2008)
Banners (1997)
Payflow Pro Jar (2002)
Addlineitems SKU peramiter (2002)
calculating unique time (1998)
Sku numbers (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Emailer setup (1997)
Press Release hit the NewsWire!!! (1997)
[Case] on OS X (2000)
Quit revisited (1997)
[WebDNA] File Include HTM (2008)
Deleting Orders (1997)
2.1b3 --> way slow (1997)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)