Re: Calculate UnitShipCost in Formulas.db
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 24864
interpreted = N
texte = >>I tried this and doesn't work.>in the invoice.tmpl I put inside the [lineitems] context something like:>[line items]>[SetLineItem>cart=[cart]&index=[lineindex]&db=products.db]unitShipCost=[math][unitShipCo>st]*[lookup>db=FactorFlete.db&value=[shipVia]&lookinfield=ShipCity&returnfield=ShipFact>or][/math][/SetLineItem]$[format thousands .2f][unitShipCost][/format]>[/lineitems]>>It show the unitShipCost I have in the database but not the one>calculated into the [setlineitems] context.You must use the price change password to change the unitshipcost in a setlineitem context. The default password is password this can be changed in the WebCatalog preferences.Here is the syntax:[setlineitem cart=[cart]&index=[lineindex]]unitshipcost=[whatever]&password=passwor d[/setlineitem]This is a security feature of WebCatalog.John Jakovich | ==Ecommerce and Beyond==Smith Micro Software Inc. | http://www.smithmicro.com-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to
.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
Associated Messages, from the most recent to the oldest:
>>I tried this and doesn't work.>in the invoice.tmpl I put inside the [lineitems] context something like:>[line items]>[SetLineItem>cart=[cart]&index=[lineindex]&db=products.db]unitShipCost=[math][unitShipCo>st]*[lookup>db=FactorFlete.db&value=[shipVia]&lookinfield=ShipCity&returnfield=ShipFact>or][/math][/SetLineItem]$[format thousands .2f][unitShipCost][/format]>[/lineitems]>>It show the unitShipCost I have in the database but not the one>calculated into the [setlineitems] context.You must use the price change password to change the unitshipcost in a setlineitem context. The default password is password this can be changed in the WebCatalog preferences.Here is the syntax:[setlineitem cart=[cart]&index=[lineindex]]unitshipcost=[whatever]&password=passwor d[/setlineitem]This is a security feature of WebCatalog.John Jakovich | ==Ecommerce and Beyond==Smith Micro Software Inc. | http://www.smithmicro.com-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
Smith Micro Support
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:
website pro trouble (1998)
.htaccess to make WebDNA serve HTML (2007)
WC2.0 Memory Requirements (1997)
Same Database needed on two machines (2002)
[format xs] freeze (1997)
LOOP and IF statements (1997)
WebCat2 - Getting to the browser's username/password data (1997)
[WebDNA] .htm files (2008)
how to set a new cart number periodically (1999)
Authenticate Questions (2003)
Pithy questions on webcommerce & siteedit (1997)
Width & Height (1998)
Search context not finding recent entries (1998)
Bug Report, maybe (1997)
[WebDNA] Build Name for 6.1 (2008)
Template Not Found (1998)
Price problem (1997)
form (2002)
Search Question (2000)
database paths/names, and a typo (1997)