Re: [lookup] is case-sensitive, [lookup] is case sensitive...
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 50895
interpreted = N
texte = Thanks, Ken, I will try all of your suggestions.-DanOn Wed, 4 Jun 2003 00:07:36 Kenneth Grome
wrote:>>I spoke too soon....Anybody see any syntax errors with the following code? My brain hurts.>>>>------------------------------------------------------------------------------------------------->>[format .2f][math][payment_gross]-([lookup >>db=IPN.db&lookinfield=INVOICE&value=[invoice]&returnfield=CPG_subtotal]+[tax]+[payment_fee])[/math][/format]>>------------------------------------------------------------------------------------------------->>>> From what I recall, the only parameter in a lookup that's case >sensitive is the value parameter.>>In your code above, a problem may arise if the value in the CPG_subtotal field is not a number, >or if the [payment_gross] or [tax] or [payment_fee] values are not all numbers, because then the >math won't work, and that will cause the format to fail as well.>>You may want to use the notfound=0 parameter in the lookup to insure that if the lookup fails, >the resulting value will be a number instead of null. Of course this will not help if any other >variable value mentioned above is not numeric.>>Check all the variable values to make sure they are all numbers before giving up. Oh, and you >really do not need the parentheses in the expression in the math context ... :)>-- >>Sincerely,>Kenneth Grome>------------------------------------------------------------->My programmers write WebDNA code at $18 an hour or less!>------------------------------------------------------------->>------------------------------------------------------------->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/------------------------------------------------------------http://www.StrongGraphicDesign.com(208) 319-0137 | Toll-free p/f 877-561-1656-------------------------------------------------------------------------------------------------------------------------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:
Thanks, Ken, I will try all of your suggestions.-DanOn Wed, 4 Jun 2003 00:07:36 Kenneth Grome wrote:>>I spoke too soon....Anybody see any syntax errors with the following code? My brain hurts.>>>>------------------------------------------------------------------------------------------------->>[format .2f][math][payment_gross]-([lookup >>db=IPN.db&lookinfield=INVOICE&value=[invoice]&returnfield=CPG_subtotal]+[tax]+[payment_fee])[/math][/format]>>------------------------------------------------------------------------------------------------->>>> From what I recall, the only parameter in a lookup that's case >sensitive is the value parameter.>>In your code above, a problem may arise if the value in the CPG_subtotal field is not a number, >or if the [payment_gross] or [tax] or [payment_fee] values are not all numbers, because then the >math won't work, and that will cause the format to fail as well.>>You may want to use the notfound=0 parameter in the lookup to insure that if the lookup fails, >the resulting value will be a number instead of null. Of course this will not help if any other >variable value mentioned above is not numeric.>>Check all the variable values to make sure they are all numbers before giving up. Oh, and you >really do not need the parentheses in the expression in the math context ... :)>-- >>Sincerely,>Kenneth Grome>------------------------------------------------------------->My programmers write WebDNA code at $18 an hour or less!>------------------------------------------------------------->>------------------------------------------------------------->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/------------------------------------------------------------http://www.StrongGraphicDesign.com(208) 319-0137 | Toll-free p/f 877-561-1656-------------------------------------------------------------------------------------------------------------------------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:
[protect] error page (1997)
about this server and links to who (1997)
[shell] (2002)
Format all of a sudden doesn't work (1997)
RE: Price recalc based on quantity (1997)
MacFinder -- a new WebDNA web site (1998)
Emailer... DOA but still twitching (2007)
For those of you not on the WebCatalog Beta... (1997)
Help name our technology! I found it (1997)
form image (2000)
WC2b15 - [HTMLx]...[/HTMLx] problems SOLVED! (1997)
[WebDNA] math and blank /no value (2014)
Forcing a NEWCART (1997)
filemaker - orderfile (1997)
adding up in a db (1997)
Initiating NewCart (1997)
WebCat hosting providers? (1997)
Getting Total Quantity (1997)
New Guestbook Source (1997)
How To question on setting up downloads (1997)