Re:my First Ship table

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 20963
interpreted = N
texte = Okay I now realize that my first post had numberous errors in it. But now I have corrected all the code that I Frankenstiened from various posts and examples. But it still doesn't seem to work. I guess what I don't understand is when exactly webcat looks into Formulas.db, when an item is added to the cart, or when the shopping cart is submitted to Invoice.tpl. What I am trying to do in formulas.db is have it total up quantity, and match that total to the [shipMeth] field and return [shipCost] which will then become [shipTotal] on invoice.tpl and be added to [subTotal] for the [grandTotal]my formula in formulas.db shipCost db=CustomShipping.db&eqShipMethdatarq=[ShipMeth]&eqQuantitydatarq=[math][lineit ems][quantity]+[/lineitems]0[/math]][FoundItems][shipCost][/FoundItems][/Search]Here is what customShipping.db looks like..... Quantity shipMeth shipCost 1 Ups 5.75 1 UpsBlue 12 1 FedEx 15 1 Inernational 20 2 Ups 5.75 2 UpsBlue 12 2 FedEx 15 2 Inernational 20 If I drop the [shipMeth] tag into invoice.tpl it will show me the selected method Ups ..etc. But [shiptotal] is not being affected. It won't even display [shipCost].I was thinking I could try to do this as a Lookup, but the way I understand it you can't lookup multiple fields.Can anyone see the problem?Thanks Tim Taylor Webmaster http://www.growzone.com Tim@versa.com t h e s i t e f o r t h e g r e e n i n d u s t r y 1.888.800.5904 Associated Messages, from the most recent to the oldest:

    
  1. Re:my First Ship table (PCS Technical Support 1998)
  2. Re:my First Ship table (Tim Taylor 1998)
  3. Re:my First Ship table (PCS Technical Support 1998)
  4. Re:my First Ship table (Tim Taylor 1998)
Okay I now realize that my first post had numberous errors in it. But now I have corrected all the code that I Frankenstiened from various posts and examples. But it still doesn't seem to work. I guess what I don't understand is when exactly webcat looks into formulas.db, when an item is added to the cart, or when the shopping cart is submitted to Invoice.tpl. What I am trying to do in formulas.db is have it total up quantity, and match that total to the [shipMeth] field and return [shipCost] which will then become [shipTotal] on invoice.tpl and be added to [subTotal] for the [grandTotal]my formula in formulas.db shipCost db=CustomShipping.db&eqShipMethdatarq=[ShipMeth]&eqQuantitydatarq=[math][lineit ems][quantity]+[/lineitems]0[/math]][founditems][shipCost][/FoundItems][/Search]Here is what customShipping.db looks like..... Quantity shipMeth shipCost 1 Ups 5.75 1 UpsBlue 12 1 FedEx 15 1 Inernational 20 2 Ups 5.75 2 UpsBlue 12 2 FedEx 15 2 Inernational 20 If I drop the [shipMeth] tag into invoice.tpl it will show me the selected method Ups ..etc. But [shiptotal] is not being affected. It won't even display [shipCost].I was thinking I could try to do this as a Lookup, but the way I understand it you can't lookup multiple fields.Can anyone see the problem?Thanks Tim Taylor Webmaster http://www.growzone.com Tim@versa.com t h e s i t e f o r t h e g r e e n i n d u s t r y 1.888.800.5904 Tim Taylor

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:

Variables for chat (1997) WebCat2b15MacPlugin - [protect] (1997) RE: [WebDNA] Installing WebDNA on VPS (2008) Interfacing WebMerchant to www.fedex.com (1997) Protect vs Authenicate (1997) Press Release hit the NewsWire!!! (1997) WebCat2 several catalogs? (1997) mail on NT (1998) [CART] inside a [LOOP] (1997) Hint: WebDNA with MySQL 4.1.x (2005) question: webmerchant connection (1997) Faxing orders in place of email (1997) syntax question, not in online refernce (1997) WC results --> Access/Filemaker (1998) [LOOKUP] (1997) PCS Frames-Default page is solution! (1997) Help name our technology! I found it (1997) Online reference (1997) searchable list archive (1997) Happy Holidays! (1998)