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 Perosi Psi Prime, Inc. http://www.psiprime.com 323 Union Blvd. Totowa, NJ 07512 P: 973.225.9870 F: 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 -0400 To: "WebDNA Talk" <WebDNA-Talk@talk.smithmicro.com> 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 <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:
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 Perosi Psi Prime, Inc. http://www.psiprime.com 323 Union Blvd. Totowa, NJ 07512 P: 973.225.9870 F: 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 -0400 To: "WebDNA Talk" <WebDNA-Talk@talk.smithmicro.com> 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 <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:
remotely add + sign (1997)
Errata: WCS Newbie question (1997)
dos performance (1998)
Database access (2003)
WebCat2: Found Items syntax, etc. (1997)
difference between v.6 and v.7, WAS: [WebDNA] v7 thisurl has different behavour (2012)
[WebDNA] SHA-256 (2015)
Simple way to create unique SKU (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
errormessages.db (1997)
emailer (1997)
WebCatalog seems to choke on large (2meg) html files. (1998)
Multiple SSL Keys (1998)
upgrading (1997)
[SMSI] WebDNA is too good to go away! (2006)
Textarea Breaks (2000)
How did *you* learn Web Catalog? (2000)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Country & Ship-to address & other fields ? (1997)
WebCat cannot handle compatible search parameters? (1997)