Re: Updating Integer value in DB

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 68682
interpreted = N
texte = > 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? Your variable name and db field name must match (but is not case-sensitive). If your db field name is ON HAND, then your variable must be [ON HAND] If your db field name is ON_HAND, then your variable must be [ON_HAND] Problem with spaces, though, is that they leave you exposed to having the space [url]'ed into %20 or otherwise misinterpreted for your purposes so that while you think the db field name is ON HAND, it may in fact be ON%20HAND. Safest to do ON_HAND rather than ON HAND to avoid the issue alltogether, or even to call it OnHand or onHand -Dan ------------------------------------------------------------- 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)
> 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? Your variable name and db field name must match (but is not case-sensitive). If your db field name is ON HAND, then your variable must be [ON HAND] If your db field name is ON_HAND, then your variable must be [ON_HAND] Problem with spaces, though, is that they leave you exposed to having the space [url]'ed into %20 or otherwise misinterpreted for your purposes so that while you think the db field name is ON HAND, it may in fact be ON%20HAND. Safest to do ON_HAND rather than ON HAND to avoid the issue alltogether, or even to call it OnHand or onHand -Dan ------------------------------------------------------------- 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/ "Dan Strong"

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:

Admin User - Users.db (1999) Version clarification, please ... (1998) formulas.db (1999) show all problem (1997) form data submission get (1997) WebCat2b15MacPlugin - [protect] (1997) Another question (1997) Imagemagick, webdna, etc (2006) This is an odd error (2001) Problem Transferring Variable Values (1998) Now you see it now you donīt (1997) [append] (1998) WebCatalog/Mac 2.1b2 New Features (1997) Error: Too many nested [xxx] contexts (1997) More on [purchase] (1998) Running _every_ page through WebCat ? (1997) Date Sorting (1997) WebDNA 6.0 & MAC OS X Server 10.4.10 (2007) PCS Frames (1997) Exists? (1997)