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:

    
  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)
> 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)