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:

    
  1. Re: math with multiple [founditems] (Kenneth Grome 1999)
  2. Re: math with multiple [founditems] (es-sleestak 1999)
  3. Re: math with multiple [founditems] (es-sleestak 1999)
  4. Re: math with multiple [founditems] (Kenneth Grome 1999)
  5. Re: math with multiple [founditems] (PCS Technical Support 1999)
  6. Re: math with multiple [founditems] (es-sleestak 1999)
  7. Re: math with multiple [founditems] (Howard Wolosky 1999)
  8. Re: math with multiple [founditems] (charles kline 1999)
  9. math with multiple [founditems] (es-sleestak 1999)
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:

Why don't Typhoon & Firesite work together? (and webcat) (1998) Locking up with WebCatalog... (1997) Bug Report, maybe (1997) Plugin or CGI or both (1997) HTML Editors (1997) PCS Frames (1997) [OT] Theiving B*****ds (2004) [WriteFile] problems (1997) [SearchString] problem with [search] context (1997) [SearchString] usage (1997) webcat- multiple selection in input field (1997) Full text search (1999) Cool new site (1996) [WebDNA] Sort Direction matches the written to file order (2015) ConvertChars (1998) Date problems (1997) Newbie problem blah blah blah (1997) Title not showing up in ViewOrder template (1998) Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997) [append] vs. [appendfile] delta + question? (1997)