pricing continued

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21086
interpreted = N
texte = I'm still trying to get Webcatalog to provide me with pricing based on the customer ID, and I think that I have it narrowed down to not finding my formulas.db for some reason. For example, when I place the code: [lookup db=price1.db&lookinfield=SKU&value=[SKU]&returnfield=price] in my results.tpl, it displays the price I want. However, when I set my formulas.db as follows I get 0.00 returned for the price in my cart.tpl: price [lookup db=price1.db&lookinfield=SKU&value=[SKU]&returnfield=price]The way I understand it, if there is a price entry in the formulas.db it should supersede the price in the catalog db. Any suggestions as to what I am doing wrong.As always, thanks for your inputSteve Puchalski Spuchalski@alltechemail.com Associated Messages, from the most recent to the oldest:

    
  1. RE: pricing continued (Puchalski, Steve 1998)
  2. RE: pricing continued (PCS Technical Support 1998)
  3. RE: pricing continued (Puchalski, Steve 1998)
  4. Re: pricing continued (PCS Technical Support 1998)
  5. pricing continued (Puchalski, Steve 1998)
I'm still trying to get Webcatalog to provide me with pricing based on the customer ID, and I think that I have it narrowed down to not finding my formulas.db for some reason. For example, when I place the code: [lookup db=price1.db&lookinfield=SKU&value=[SKU]&returnfield=price] in my results.tpl, it displays the price I want. However, when I set my formulas.db as follows I get 0.00 returned for the price in my cart.tpl: price [lookup db=price1.db&lookinfield=SKU&value=[SKU]&returnfield=price]The way I understand it, if there is a price entry in the formulas.db it should supersede the price in the catalog db. Any suggestions as to what I am doing wrong.As always, thanks for your inputSteve Puchalski Spuchalski@alltechemail.com Puchalski, Steve

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:

WebCat2 beta 11 - new prefs ... (1997) webcat serving multiple copies of same db from ram (2000) Date calculation problems (1997) nesting limits? (1998) Getting Emailer to send mail (1997) Shop till you drop dead on the avenue ... (1997) totals (1997) Loop into field (1998) Using Cookie for client specific info? (1997) FlushDatabase Suggestion (1998) So, does anyone have developer editon running on Win XP Pro? (2006) Searching for all records (1998) [authenticate] (1999) trouble updating records in database (1998) Re:2nd WebCatalog2 Feature Request (1996) More DateMath problems (1997) How do I specify a & character in Grep? (2000) Handy Browser Counter Tip (1997) Emailer setup (1997) Search Engine questions ... (2002)