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:
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 into
formulas.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!
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)