Re: Price and Formula.db
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45508
interpreted = N
texte = exactly the same issue as me. took me about 4 days and i have no idea what idid to get it to work but now it does and im not touching it.i think the formulas database is probably one of the worst parts ofwebcatalog in terms of not working the way you expect it to.its a subject that nobody likes cause nobody understands it when it doesn'twork.My suggestion is to bin the whole lot and go with something a lot moreeasily understandable - you will go mental trying to figure it out.----- Original Message -----From: Glenn Busbin
To: WebCatalog Talk Sent: Wednesday, November 20, 2002 1:39 PMSubject: Re: Price and Formula.db> I've tried everything I can think of, everything you guys suggested, andeverything I can find in the archives. I have to fall back on the there's abug in WC4.x Mac Classic and OS X that prevents Formulas.db from working.>> Here's the entire Formulas.db:> Name Formula> Price [Math][lookupdb=Products.db&lookinfield=SKU&value=[URL][SKU][/URL]&returnfield=Price]+([lookupdb=Products.db&lookinfield=SKU&value=[URL[SKU][/URL&returnfield=Price]*[lookupdb=Woods.db&lookinfield=Woods&value=[URL][Woods][/URL]&returnfield=ExtraCost])[/Math]> Taxable F> UNITSHIPCOST 0.00> SHIPCOST 0.00> TAXRATE 0.00>> Test 1- This formula will put 0.00 in the Price field of a ShoppingCarttemplate 100% of the time.>> Test 2- If I change the Price formula to:> [Math][lookupdb=Products.db&lookinfield=SKU&value=[URL][SKU][/URL]&returnfield=Price]+10[/Math]>> it will add 10 to the price from the Products.db 100% of the time.>> Test 3- If I put> [Math=Show]X=[lookupdb=Products.db&lookinfield=SKU&value=[URL][SKU][/URL]&returnfield=Price]+([lookupdb=Products.db&lookinfield=SKU&value=[URL[SKU][/URL&returnfield=Price]*[lookupdb=Woods.db&lookinfield=Woods&value=[URL][Woods][/URL]&returnfield=ExtraCost])[/Math]>> into a template with the SKU and Woods variables carried from anothertemplate, it will show the correct value for X.>> Test 4- The lookups will also return the correct values if put into atemplate as two separate lookups.>> Test 5- If I put the individual lookups into the lineitems loop in theShoppingCart.tpl, it will they both return the correct values.>> SmithMicro, you created this mess. Although I don't expect you to respondto questions about your products, what do I tell the client and how do I getthe calculated price into a shopping cart based on the price of the itemplus the options?>> Using a password in the add command is insecure and therefore not anoption.>> Glenn>> -------------------------------------------------------------> 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://search.smithmicro.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
exactly the same issue as me. took me about 4 days and i have no idea what idid to get it to work but now it does and im not touching it.i think the formulas database is probably one of the worst parts ofwebcatalog in terms of not working the way you expect it to.its a subject that nobody likes cause nobody understands it when it doesn'twork.My suggestion is to bin the whole lot and go with something a lot moreeasily understandable - you will go mental trying to figure it out.----- Original Message -----From: Glenn Busbin To: WebCatalog Talk Sent: Wednesday, November 20, 2002 1:39 PMSubject: Re: Price and Formula.db> I've tried everything I can think of, everything you guys suggested, andeverything I can find in the archives. I have to fall back on the there's abug in WC4.x Mac Classic and OS X that prevents formulas.db from working.>> Here's the entire formulas.db:> Name Formula> Price [math][lookupdb=Products.db&lookinfield=SKU&value=[url][SKU][/URL]&returnfield=Price]+([lookupdb=Products.db&lookinfield=SKU&value=[URL[SKU][/URL&returnfield=Price]*[lookupdb=Woods.db&lookinfield=Woods&value=[url][Woods][/URL]&returnfield=ExtraCost])[/Math]> Taxable F> UNITSHIPCOST 0.00> SHIPCOST 0.00> TAXRATE 0.00>> Test 1- This formula will put 0.00 in the Price field of a ShoppingCarttemplate 100% of the time.>> Test 2- If I change the Price formula to:> [math][lookupdb=Products.db&lookinfield=SKU&value=[url][SKU][/URL]&returnfield=Price]+10[/Math]>> it will add 10 to the price from the Products.db 100% of the time.>> Test 3- If I put> [Math=Show]X=[lookupdb=Products.db&lookinfield=SKU&value=[url][SKU][/URL]&returnfield=Price]+([lookupdb=Products.db&lookinfield=SKU&value=[URL[SKU][/URL&returnfield=Price]*[lookupdb=Woods.db&lookinfield=Woods&value=[url][Woods][/URL]&returnfield=ExtraCost])[/Math]>> into a template with the SKU and Woods variables carried from anothertemplate, it will show the correct value for X.>> Test 4- The lookups will also return the correct values if put into atemplate as two separate lookups.>> Test 5- If I put the individual lookups into the lineitems loop in theShoppingCart.tpl, it will they both return the correct values.>> SmithMicro, you created this mess. Although I don't expect you to respondto questions about your products, what do I tell the client and how do I getthe calculated price into a shopping cart based on the price of the itemplus the options?>> Using a password in the add command is insecure and therefore not anoption.>> Glenn>> -------------------------------------------------------------> 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://search.smithmicro.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://search.smithmicro.com/
Andrew Simpson
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:
Dates - Search and Sorting (1999)
shortening the cart (1998)
won't serve .tpl -index.tpl gone, made test.tpl (2000)
Re:PCS Customer submissions ? (1997)
New global preference ... ??? (2000)
rotating thumbnails (1997)
Shared conversion under WebTen (1998)
RE: ShowNext Command (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
rotating thumbnails (1997)
WebCatalog Upgrade Pricing? (1997)
No luck with taxes (1997)
Replacing entry (1998)
Attn: Bug in GeneralStore example b15 (1997)
Plugin or CGI or both (1997)
New Webcatalog for Mac (1997)
WC2.0 Memory Requirements (1997)
wish list (2002)
Form based Redirect (2001)
[Announce] Newest Commerce Site based on WebCatalog (1997)