Re: Forumulas.db & Variables

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45864
interpreted = N
texte = On 12/1/02 10:05 PM, Donovan Brooke wrote:> Jesse, I would say that I can't really help unless I see the exact > code you are working with. both the formulas.db > and the significant code on the addlineitem page...(including > any setheadering or appropriate var setting.Sure thing.I got the shipvia problem resolved but State still isn't working. If I put [state] in the page right above where it should show the tax total, it shows. If I put my Formula right above where the tax total would show, it displays correctly, but if I put the formula back in the formulas.db then it doesn't work again. I've tired these two formulas:[orderfile cart=[cart]][showif [url][state][/url]=WA]8.25[/showif][/orderfile]And[showif [url][state][/url]=WA]8.25[/showif]Basically, all the users information gets posted to a page that does a set header and then below it tries to display the taxtotal:[setheader cart=[cart]]ShipVia=[url][ShipVia][/url]&shiptocountry=[url][shiptocountry][ /url]&header30=[url][sd][/url]&email=[url][email][/url]&header1=[url][header 1][/url]&header2=[url][header2][/url]&company=[url][company][/url]&address1= [url][address1][/url]&phone=[url][phone][/url]&address2=[url][address2][/url ]&city=[url][city][/url]&country=[url][country][/url]&state=[url][state][/ur l]&zip=[url][zip][/url]&header3=[url][header3][/url]&header4=[url][header4][ /url]&shiptocompany=[url][shiptocompany][/url]&shiptoaddress1=[url][shiptoad dress1][/url]&shiptophone=[url][shiptophone][/url]&shiptoaddress2=[url][ship toaddress2][/url]&shiptocity=[url][shiptocity][/url]&shiptostate=[url][shipt ostate][/url]&shiptozip=[url][shiptozip][/url][/setheader][orderfile cart=[cart]] [hideif [url][taxtotal][/url]=0.00] (Tax Rate: [taxRate]%) Tax Total: $[format .2f][taxtotal][/format] [/hideif] [/orderfile]Ideas?-- Jesse Williams-Proudman || CEO NineWire Digital Solutions || +1.888.873.6199 jesse@ninewire.com || http://ninewire.com Mac Web Hosting & Colocation || Mac Nationwide Dialup Xserve Colocation Special, $75 / Month http://www.ninewire.com ------------------------------------------------------------- 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:

    
  1. Re: Forumulas.db & Variables (Donovan 2002)
  2. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  3. Re: Forumulas.db & Variables (Alain Russell 2002)
  4. Re: Forumulas.db & Variables (Andrew Simpson 2002)
  5. Re: Forumulas.db & Variables (Alain Russell 2002)
  6. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  7. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  8. Re: Forumulas.db & Variables (Donovan 2002)
  9. Re: Forumulas.db & Variables (Donovan 2002)
  10. Re: Forumulas.db & Variables (Gary Krockover 2002)
  11. Re: Forumulas.db & Variables (John Peacock 2002)
  12. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  13. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  14. Re: Forumulas.db & Variables (Donovan 2002)
  15. Re: Forumulas.db & Variables (Donovan 2002)
  16. Re: Forumulas.db & Variables (John Peacock 2002)
  17. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  18. Re: Forumulas.db & Variables (Donovan 2002)
  19. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  20. Re: Forumulas.db & Variables (Donovan Brooke 2002)
  21. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  22. Re: Forumulas.db & Variables (Donovan Brooke 2002)
  23. Re: Forumulas.db & Variables (Donovan Brooke 2002)
  24. Re: Forumulas.db & Variables (Donovan Brooke 2002)
  25. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  26. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  27. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  28. Re: Forumulas.db & Variables (WJ Starck 2002)
  29. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  30. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  31. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  32. Re: Forumulas.db & Variables (WJ Starck 2002)
  33. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  34. Re: Forumulas.db & Variables (Donovan Brooke 2002)
  35. Re: Forumulas.db & Variables (Donovan Brooke 2002)
  36. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  37. Re: Forumulas.db & Variables (Donovan Brooke 2002)
  38. Re: Forumulas.db & Variables (Donovan Brooke 2002)
  39. Re: Forumulas.db & Variables (Larry Goodhew 2002)
  40. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  41. Re: Forumulas.db & Variables (Gary Krockover 2002)
  42. Re: Forumulas.db & Variables (Larry Goodhew 2002)
  43. Re: Forumulas.db & Variables (WJ Starck 2002)
  44. Re: Forumulas.db & Variables (Larry Goodhew 2002)
  45. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  46. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  47. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  48. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  49. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  50. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  51. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  52. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  53. Re: Forumulas.db & Variables (WJ Starck 2002)
  54. Re: Forumulas.db & Variables (Jesse Williams-Proudman 2002)
  55. Re: Forumulas.db & Variables (Glenn Busbin 2002)
  56. Forumulas.db & Variables (Jesse Williams-Proudman 2002)
On 12/1/02 10:05 PM, Donovan Brooke wrote:> Jesse, I would say that I can't really help unless I see the exact > code you are working with. both the formulas.db > and the significant code on the addlineitem page...(including > any setheadering or appropriate var setting.Sure thing.I got the shipvia problem resolved but State still isn't working. If I put [state] in the page right above where it should show the tax total, it shows. If I put my Formula right above where the tax total would show, it displays correctly, but if I put the formula back in the formulas.db then it doesn't work again. I've tired these two formulas:[orderfile cart=[cart]][showif [url][state][/url]=WA]8.25[/showif][/orderfile]And[showif [url][state][/url]=WA]8.25[/showif]Basically, all the users information gets posted to a page that does a set header and then below it tries to display the taxtotal:[setheader cart=[cart]]ShipVia=[url][ShipVia][/url]&shiptocountry=[url][shiptocountry][ /url]&header30=[url][sd][/url]&email=[url][email][/url]&header1=[url][header 1][/url]&header2=[url][header2][/url]&company=[url][company][/url]&address1= [url][address1][/url]&phone=[url][phone][/url]&address2=[url][address2][/url ]&city=[url][city][/url]&country=[url][country][/url]&state=[url][state][/ur l]&zip=[url][zip][/url]&header3=[url][header3][/url]&header4=[url][header4][ /url]&shiptocompany=[url][shiptocompany][/url]&shiptoaddress1=[url][shiptoad dress1][/url]&shiptophone=[url][shiptophone][/url]&shiptoaddress2=[url][ship toaddress2][/url]&shiptocity=[url][shiptocity][/url]&shiptostate=[url][shipt ostate][/url]&shiptozip=[url][shiptozip][/url][/setheader][orderfile cart=[cart]] [hideif [url][taxtotal][/url]=0.00] (Tax Rate: [taxRate]%) Tax Total: $[format .2f][taxtotal][/format] [/hideif] [/orderfile]Ideas?-- Jesse Williams-Proudman || CEO NineWire Digital Solutions || +1.888.873.6199 jesse@ninewire.com || http://ninewire.com Mac Web Hosting & Colocation || Mac Nationwide Dialup Xserve Colocation Special, $75 / Month http://www.ninewire.com ------------------------------------------------------------- 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/ Jesse Williams-Proudman

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:

WebMerchant 2.1.2 (1998) What is the maximum record length? (1998) Shopping cart problem (2003) Mac app. that converts e-mails (2000) email address with spaces (2001) Pop-up menu (1998) [shippingtotal] still... (2002) WebCat and WebTV (1997) WebCat2 several catalogs? (1997) emailer (1997) oops private message leaked into talk list (1997) NT error logs (1997) Zip Code Search (2000) strange [Shell] things / Linux.2 (2000) More on the email templates (1997) Cart Already Submitted (2003) limitation found on group searching (1997) GoLive CyberStudio 1.0.1 (1997) WebMerchant 1.6 and SHTML (1997) WebCat2b12 - nesting [tags] (1997)