Re: math with multiple [founditems]
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23768
interpreted = N
texte = Yep that gets rid of the plus sign but I'm still not adding all the values together.When I do this: [search db=MeriselInv.txt&eqSKUdata=95654] [founditems] [getchars start=2][invonhand][/getchars]
[/founditems] [/search] I get this: 0000456 0000434 0000617 0000616 0000330 0000511It tried this: [math show=f]TotalCount=0[/math] [search db=MeriselInv.txt&eqSKUdata=95654] [founditems] [math show=f]TotalCount=TotalCount+[getchars start=2][invonhand][/getchars][/math] [/founditems] [/search] and got nothing!I need to add all those values together from the first search above. It seems like this shouldn't be too difficult but I'm having a heck of a time finding a simple solution. :)Thanks again for your help Brant Kenneth Grome wrote:> >To make things even more slippery the values of the InvOnHand > >field looks something like this: +0000616. > > That's the problem! > > What's the plus sign doing in a numeric value field? If that's what all your [invonhand] field values look like, you have to get rid of those plus signs like this: > > [getchars start=2][invonhand][/getchars] > > then it will probably work ... unless you have unusual values in other fields as well ... :) > > Sincerely, > Ken Grome > WebDNA Consultant
Associated Messages, from the most recent to the oldest:
Yep that gets rid of the plus sign but I'm still not adding all the values together.When I do this: [search db=MeriselInv.txt&eqSKUdata=95654]
[founditems] [getchars start=2][invonhand][/getchars]
[/founditems] [/search] I get this: 0000456 0000434 0000617 0000616 0000330 0000511It tried this: [math show=f]TotalCount=0[/math] [search db=MeriselInv.txt&eqSKUdata=95654]
[founditems] [math show=f]TotalCount=TotalCount+[getchars start=2][invonhand][/getchars][/math] [/founditems] [/search] and got nothing!I need to add all those values together from the first search above. It seems like this shouldn't be too difficult but I'm having a heck of a time finding a simple solution. :)Thanks again for your help Brant Kenneth Grome wrote:> >To make things even more slippery the values of the InvOnHand > >field looks something like this: +0000616. > > That's the problem! > > What's the plus sign doing in a numeric value field? If that's what all your [invonhand] field values look like, you have to get rid of those plus signs like this: > > [getchars start=2][invonhand][/getchars] > > then it will probably work ... unless you have unusual values in other fields as well ... :) > > Sincerely, > Ken Grome > WebDNA Consultant
es-sleestak
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:
Include from DB (2002)
Cart Question (1998)
gateway application timeouts (1998)
WebCat2b15MacPlugin - showing [math] (1997)
Multiple catalog databases and showcart (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
[OT] CSS and SSI books (2004)
[lookup] speed sales pitch (2003)
frames & carts (1997)
Re[2]: shipCost -vs- shippingtotal ? (2000)
hotmail filtering emails (2004)
Security Question (1997)
Netscape Error Message Document Contains No Data (1998)
Looking up two prices in database? (1997)
E-mailer error codes (1997)
Client-side Image Maps and WebCat? (1998)
WebCatalog can't find database (1997)
NetScape problem (1999)
wired [protect] action? (1998)
sendmail (2000)