Re: math with multiple [founditems]

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23774
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 >0000511 > >It 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. :)Your search can find only one record when your search parameters are eqSKUdata=95654, and unless there's actually a record in the db with the exact sku 95654, your search won't even find one record. Try a search that actually retrieves more than one record ... :)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 >0000511 > >It 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. :)Your search can find only one record when your search parameters are eqSKUdata=95654, and unless there's actually a record in the db with the exact sku 95654, your search won't even find one record. Try a search that actually retrieves more than one record ... :)Sincerely, Ken Grome WebDNA Consultant Kenneth Grome

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:

Associative lookup style? + bit more (1997) Emailer help....! (1997) Sendmail & Time Issue (2001) ignore (test) (2000) [WriteFile] problems (1997) Re:2nd WebCatalog2 Feature Request (1996) [WebDNA] Did everything in ReadMe.txt and it still doesn't work (2013) Sku numbers (1997) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) Test (2001) RE: Languages (1997) Re:Sizes and colors (1999) WebCatalog2 for NT Beta Request (1997) BBEdit and WebCatalog 2.0? (1997) Newbie questions (2000) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Working HTML email (2001) Extended [ConvertChars] (1997) [ShowNext] (1997) form data submission gets truncated (1997)