Allowed fields in formulas.db

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16787
interpreted = N
texte = GenevaHi Im using the 30 day demo version of WebCat 2.1.1 on a mac, so far I am pretty impressed and will almost certainly be buying the full version. One problem I do need help with is the formula.db, I have read a few posts in the last couple of days re allowed field etc. but do not really understand.Are there fields that you can not use in the formulas.db ? I have a big formula that works out local product prices based on [country] selection in the previous template.This works when on the product template: [math][format 10.0f][math](([math][lookup db=rates.db&LookInField=country&value=[country]&returnfield=exchangerate]*[format 10.2f][math]([format 8.2f][math][lookup db=products.db&LookInField=SKU&value=NK1967Geneva&returnfield=price]/1.175[/math][/format])[/math][/format][/math])/[lookup db=rates.db&LookInField=country&value=[country]&returnfield=rounding])[/math][/format]*[lookup db=rates.db&LookInField=country&value=[country]&returnfield=rounding][/math] When I try to use this in the formula.db for price in the final cart it just gets ignored and the base price from the products.db appears instead. In fact I just tried a simple formula: [math][lookup db=products.db&LookInField=SKU&value=NK1967Geneva&returnfield=price]*2[/math] and the same result.Shouldn't the price be pulled automatically from the formulas.db if there is one? Paul Willis Associated Messages, from the most recent to the oldest:

    
  1. Re: Allowed fields in formulas.db (Paul Willis 1998)
  2. Re: Allowed fields in formulas.db (PCS Technical Support 1998)
  3. Allowed fields in formulas.db (Paul Willis 1998)
GenevaHi Im using the 30 day demo version of WebCat 2.1.1 on a mac, so far I am pretty impressed and will almost certainly be buying the full version. One problem I do need help with is the formula.db, I have read a few posts in the last couple of days re allowed field etc. but do not really understand.Are there fields that you can not use in the formulas.db ? I have a big formula that works out local product prices based on [country] selection in the previous template.This works when on the product template: [math][format 10.0f][math](([math][lookup db=rates.db&LookInField=country&value=[country]&returnfield=exchangerate]*[format 10.2f][math]([format 8.2f][math][lookup db=products.db&LookInField=SKU&value=NK1967Geneva&returnfield=price]/1.175[/math][/format])[/math][/format][/math])/[lookup db=rates.db&LookInField=country&value=[country]&returnfield=rounding])[/math][/format]*[lookup db=rates.db&LookInField=country&value=[country]&returnfield=rounding][/math] When I try to use this in the formula.db for price in the final cart it just gets ignored and the base price from the products.db appears instead. In fact I just tried a simple formula: [math][lookup db=products.db&LookInField=SKU&value=NK1967Geneva&returnfield=price]*2[/math] and the same result.Shouldn't the price be pulled automatically from the formulas.db if there is one? Paul Willis Paul Willis

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:

Summing fields (1997) [Q] Novice's question (1997) Truncated numbers (2000) Using WC for Bulk Emailings (1997) WebCatalog usage (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) OT - asp snippet similar to [!][/!] (2003) Requiring that certain fields be completed (1997) dates and hex formatting (1997) Saving/Looking Up customer numbers (1998) WebMerchant -- Sweeping WebDelivery < 24 hrs (2000) Selected Item in Pop-down (2003) Help name our technology! (1997) Protect (1997) Ok here is a question? (1997) Quit revisited (1997) quantity minimum problem (1997) email [title] (1997) A multi-processor savvy WebCatalog? (1997) URGENT - CPU usage OSXS (2001)