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 nowI have corrected all the code that I Frankenstiened from various posts andexamples. But it still doesn't seem to work.I guess what I don't understand is when exactly webcat looks intoFormulas.db, when an item is added to the cart, or when the shopping cartis submitted to Invoice.tpl.What I am trying to do in formulas.db is have it total up quantity, andmatch that total to the [shipMeth] field and return [shipCost] which willthen become [shipTotal] on invoice.tpl and be added to [subTotal] for the[grandTotal]my formula in formulas.dbshipCost db=CustomShipping.db&eqShipMethdatarq=[ShipMeth]&eqQuantitydatarq=[math][lineitems][quantity]+[/lineitems]0[/math]][FoundItems][shipCost][/FoundItems][/Search]Here is what customShipping.db looks like.....Quantity shipMeth shipCost1 Ups 5.751 UpsBlue 121 FedEx 151 Inernational 202 Ups 5.752 UpsBlue 122 FedEx 152 Inernational 20 If I drop the [shipMeth] tag into invoice.tpl it will show me the selectedmethod Ups ..etc. But [shiptotal] is not being affected. It won't evendisplay [shipCost].I was thinking I could try to do this as a Lookup, but the way I understandit you can't lookup multiple fields.Can anyone see the problem?ThanksTim TaylorWebmasterhttp://www.growzone.comTim@versa.comt h e s i t e f o r t h eg r e e n i n d u s t r y1.888.800.5904 Associated Messages, from the most recent to the oldest:

Re:my First Ship table (PCS Technical Support 1998)
Re:my First Ship table (Tim Taylor 1998)
Re:my First Ship table (PCS Technical Support 1998)
Re:my First Ship table (Tim Taylor 1998)

Okay I now realize that my first post had numberous errors in it. But nowI have corrected all the code that I Frankenstiened from various posts andexamples. But it still doesn't seem to work.I guess what I don't understand is when exactly webcat looks intoformulas.db, when an item is added to the cart, or when the shopping cartis submitted to Invoice.tpl.What I am trying to do in formulas.db is have it total up quantity, andmatch that total to the [shipMeth] field and return [shipCost] which willthen become [shipTotal] on invoice.tpl and be added to [subTotal] for the[grandTotal]my formula in formulas.dbshipCost db=CustomShipping.db&eqShipMethdatarq=[ShipMeth]&eqQuantitydatarq=[math][lineitems][quantity]+[/lineitems]0[/math]][founditems][shipCost][/FoundItems][/Search]Here is what customShipping.db looks like.....Quantity shipMeth shipCost1 Ups 5.751 UpsBlue 121 FedEx 151 Inernational 202 Ups 5.752 UpsBlue 122 FedEx 152 Inernational 20 If I drop the [shipMeth] tag into invoice.tpl it will show me the selectedmethod Ups ..etc. But [shiptotal] is not being affected. It won't evendisplay [shipCost].I was thinking I could try to do this as a Lookup, but the way I understandit you can't lookup multiple fields.Can anyone see the problem?ThanksTim TaylorWebmasterhttp://www.growzone.comTim@versa.comt h e s i t e f o r t h eg r e e n i n d u s t r y1.888.800.5904 Tim Taylor

DOWNLOAD WEBDNA NOW!

Re:my First Ship table

1998

Top Articles:

Related Readings: