Re: Price and Formula.db
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45515
interpreted = N
texte = Did you copy/paste that formula? If so, you're missing some brackets onyour URL's:SKU&value=[URL[SKU][/URL&returnfield=PriceGK> 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/
Associated Messages, from the most recent to the oldest:
Did you copy/paste that formula? If so, you're missing some brackets onyour URL's:SKU&value=[URL[SKU][/URL&returnfield=PriceGK> 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/
Gary Krockover
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/ Mac Auth. and CC refunds (1998)
MacAuthorize order data fields WAS:How To question... (1997)
2nd WebCatalog2 Feature Request (1996)
select multiple (1997)
trouble updating records in database (1998)
WebCat2b15MacPlugin - showing [math] (1997)
problems with 2 tags (1997)
Multiple Pulldowns (1997)
much help needed NEWBIE alert (2000)
[foundItems] context problem (2000)
Updating database (1998)
OT: typhoon manual (2000)
Up and running ... at last !! (1997)
Credit card number for testing (2003)
Starting Emailer (2005)
Help name our technology! (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
RE: formula.db, adding option prices (1997)
Emailer help....! (1997)
OFF-TOPIC: Lending investors ... (2002)