Allowed fields in formulas.db
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16787
interpreted = N
texte =
GenevaHiIm using the 30 day demo version of WebCat 2.1.1 on a mac, so far I ampretty 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 fewposts in the last couple of days re allowed field etc. but do notreally 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][lookupdb=rates.db&LookInField=country&value=[country]&returnfield=exchangerate]*[format10.2f][math]([format 8.2f][math][lookupdb=products.db&LookInField=SKU&value=NK1967Geneva&returnfield=price]/1.175[/math][/format])[/math][/format][/math])/[lookupdb=rates.db&LookInField=country&value=[country]&returnfield=rounding])[/math][/format]*[lookupdb=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 itjust gets ignored and the base price from the products.db appearsinstead.In fact I just tried a simple formula:[math][lookupdb=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 ifthere is one?Paul Willis
Associated Messages, from the most recent to the oldest:
GenevaHiIm using the 30 day demo version of WebCat 2.1.1 on a mac, so far I ampretty 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 fewposts in the last couple of days re allowed field etc. but do notreally 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][lookupdb=rates.db&LookInField=country&value=[country]&returnfield=exchangerate]*[format10.2f][math]([format 8.2f][math][lookupdb=products.db&LookInField=SKU&value=NK1967Geneva&returnfield=price]/1.175[/math][/format])[/math][/format][/math])/[lookupdb=rates.db&LookInField=country&value=[country]&returnfield=rounding])[/math][/format]*[lookupdb=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 itjust gets ignored and the base price from the products.db appearsinstead.In fact I just tried a simple formula:[math][lookupdb=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 ifthere 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)