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:

Issue with plug-in Webcat, webstar 4.x, SSL and IE when using the backbuttom (2000) syntax question, not in online refernce (1997) CGI Request Time Out (1997) Checking for blank form fields (sort of...) (1998) shipCost not working v2.1b4 (1997) docs for WebCatalog2 (1997) 2nd WebCatalog2 Feature Request (1996) FEATURE REQUEST: (was: Summarizing results. Is there a (1999) 2.0Beta Command Ref (can't find this instruction) (1997) question: webdelivery folder and file (1997) Almost a there but..bye bye NetCloak (1997) Nesting format tags (1997) IIS4b2 and WebCatalog b19 (1997) FWD: Autoproxy Bug with WebCatalog and FireSite (1997) Can't use old cart file (was One more try) (1997) [search] within [listfiles]? (2003) Bad suffix error (1997) Interface to Quickbooks (2005) [/application] error? (1997) shipcost (1997)