Re: Updating Integer value in DB

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 68681
interpreted = N
texte = The [math] context is very picky.  It will not work correctly if the variable name includes a minus (-) or a period (.)

Example of variables that will produce failures when you try to use them inside [math][/math] are:
[math][on-hand]+1[/math]
[math][on.hand]+1[/math]
In my experience these would both produce errors.  I will assume that a space will cause the same error.  The underscore (_) character has no usage in any language, mathematical context or any other real world usage, and therefore it is a safe character to use in all variable and database field names.

Matt
-- Matthew A PerosiPsi Prime, Inc.http://www.psiprime.com323 Union Blvd.Totowa, NJ 07512P: 973.225.9870F: 973.413.8217

Ki Song wrote: 
From: Matthew A Perosi <matt@psiprime.com>Reply-To: "WebDNA Talk" <WebDNA-Talk@talk.smithmicro.com>Date: Wed, 14 Mar 2007 12:34:10 -0400To: "WebDNA Talk" <WebDNA-Talk@talk.smithmicro.com>Subject: Re: Updating Integer value in DBI used to run into a lot of problems with database fields with spaces inthem.  i.e. "ON HAND" instead of the more reliable "ON_HAND".  I'vegotten 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 [] insidethe [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 <WebDNA-Talk@talk.smithmicro.com>.To unsubscribe, E-mail to: <WebDNA-Talk-off@talk.smithmicro.com>To switch to the DIGEST mode, E-mail to <WebDNA-Talk-digest@talk.smithmicro.com>Web Archive of this list is at: http://webdna.smithmicro.com/  



-------------------------------------------------------------This message is sent to you because you are subscribed to  the mailing list <WebDNA-Talk@talk.smithmicro.com>.To unsubscribe, E-mail to: <WebDNA-Talk-off@talk.smithmicro.com>To switch to the DIGEST mode, E-mail to <WebDNA-Talk-digest@talk.smithmicro.com>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.  


  2.  Re: Updating Integer value in DB ( Matthew A Perosi  2007)
    3.  


  3.  Re: Updating Integer value in DB ( Donovan Brooke  2007)
    4.  


  4.  Re: Updating Integer value in DB ( "Dan Strong"  2007)
    5.  


  5.  Re: Updating Integer value in DB ( Matthew A Perosi  2007)
    6.  


  6.  Re: Updating Integer value in DB ( Ki Song  2007)
    7.  


  7.  Re: Updating Integer value in DB ( Jim Ziegler  2007)
    8.  


  8.  Re: Updating Integer value in DB ( Matthew A Perosi  2007)
    9.  


  9.  Updating Integer value in DB ( Ki Song  2007)
    10.  







    The [math] context is very picky.  It will not work correctly if thevariable name includes a minus (-) or a period (.)

Example of variables that will produce failures when you try to usethem inside [math][/math] are:
[math][on-hand]+1[/math]
[math][on.hand]+1[/math]
In my experience these would both produce errors.  I will assume that aspace will cause the same error.  The underscore (_) character has nousage in any language, mathematical context or any other real worldusage, and therefore it is a safe character to use in all variable anddatabase field names.

Matt

-- Matthew A PerosiPsi Prime, Inc.http://www.psiprime.com323 Union Blvd.Totowa, NJ 07512P: 973.225.9870F: 973.413.8217

Ki Song wrote:
  
    
From: Matthew A Perosi <matt@psiprime.com>Reply-To: "WebDNA Talk" <WebDNA-Talk@talk.smithmicro.com>Date: Wed, 14 Mar 2007 12:34:10 -0400To: "WebDNA Talk" <WebDNA-Talk@talk.smithmicro.com>Subject: Re: Updating Integer value in DBI used to run into a lot of problems with database fields with spaces inthem.  i.e. "ON HAND" instead of the more reliable "ON_HAND".  I'vegotten 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 [] insidethe [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 <WebDNA-Talk@talk.smithmicro.com>.To unsubscribe, E-mail to: <WebDNA-Talk-off@talk.smithmicro.com>To switch to the DIGEST mode, E-mail to <WebDNA-Talk-digest@talk.smithmicro.com>Web Archive of this list is at: http://webdna.smithmicro.com/  





-------------------------------------------------------------This message is sent to you because you are subscribed to  the mailing list <WebDNA-Talk@talk.smithmicro.com>.To unsubscribe, E-mail to: <WebDNA-Talk-off@talk.smithmicro.com>To switch to the DIGEST mode, E-mail to <WebDNA-Talk-digest@talk.smithmicro.com>Web Archive of this list is at: http://webdna.smithmicro.com/



 Matthew A Perosi 







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 - storing unformatted date data? (1997)
 
more info on [setlineitems] (1997)
 
Emailer setup (1997)
 
Protect vs Authenicate (1997)
 
still having shipCost.db Problem (1997)
 
OUTSIDE LINKS TO SHOW SHOPPING CART????????? (1998)
 
More on the email templates (1997)
 
Help! WebCat2 bug (1997)
 
Ok here is a question? (1997)
 
Tax & Shipping (1997)
 
Finding max value for a field (1997)
 
Thanks ! (1997)
 
Re:Authenticate (1998)
 
New public beta available (1997)
 
Search in 2 or more catalogs (1997)
 
HELP! 10K hits per hour for pages that no longer exist! (2000)
 
Sample Tearoom Search Error (1997)
 
Newbie problem blah blah blah (1997)
 
sendmail spaces (1997)
 
Generating Options for a Form. (1997)