special commerce fields
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 15553
interpreted = N
texte = Hi All,Mine is a problem of understanding the unitshipcost and other specialcommerce fields.What I am trying to do is develop a shopping cart type solution for a localISP to allow online signups.The products they sell are web accounts and email accounts etc. Onlyproblem is they sell on a monthly rental basis.This means for each product in the database there is an initial once offsetup cost and an ontoing monthly rental. I've figured out all thefunctions using quantity price and unitshipcost and assigned themas followsquantity = number of months advance rentalprice = the rental cost per month in $unitshipcost = the once off setup feeEverything works fine except using the quantity as the calculator for themonths also affects the calculation of the unitshipcost when I use thesubtotal and grandtotal functions.Can anyone suggest how I can get the correct subtotal and grand totalcalculation.ie. 10 months rental = (10 X price + 1 X unitshipcost) not (10 X price +10 X unitshipcost)Thanks,Tim Rignold_____________________________________________________WEBHOST.COM.AU - BRISBANE Telephone +61 7 3831 911180 Berry Street Facsimile + 61 7 3839 5442Spring Hill Queensland email tim@webhost.com.auAUSTRALIA 4000 http://www.webhost.com.auTHE LOW COST WEB AND EMAIL HOSTING ALTERNATIVE
Associated Messages, from the most recent to the oldest:
Hi All,Mine is a problem of understanding the unitshipcost and other specialcommerce fields.What I am trying to do is develop a shopping cart type solution for a localISP to allow online signups.The products they sell are web accounts and email accounts etc. Onlyproblem is they sell on a monthly rental basis.This means for each product in the database there is an initial once offsetup cost and an ontoing monthly rental. I've figured out all thefunctions using quantity price and unitshipcost and assigned themas followsquantity = number of months advance rentalprice = the rental cost per month in $unitshipcost = the once off setup feeEverything works fine except using the quantity as the calculator for themonths also affects the calculation of the unitshipcost when I use thesubtotal and grandtotal functions.Can anyone suggest how I can get the correct subtotal and grand totalcalculation.ie. 10 months rental = (10 X price + 1 X unitshipcost) not (10 X price +10 X unitshipcost)Thanks,Tim Rignold_____________________________________________________WEBHOST.COM.AU - BRISBANE Telephone +61 7 3831 911180 Berry Street Facsimile + 61 7 3839 5442Spring Hill Queensland email tim@webhost.com.auAUSTRALIA 4000 http://www.webhost.com.auTHE LOW COST WEB AND EMAIL HOSTING ALTERNATIVE
Tim Rignold
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:
(1998)
WebDNA dying or ... ? (2005)
unable to launch acgi in WebCat (1997)
SQL & [shownext] tag... (2001)
Banner DNA (1997)
AE aware WebCatalog.acgi? (1997)
carriage returns in data (1997)
Large founditems loops (2000)
logout after authenticated (2002)
Re:Emailer and encryption (1997)
Feature discussion: simple way for [url] and [convertchars] (2000)
Showing Results Alphabetically in Columns (top to bottom) (2002)
Hideif on IP range (2004)
(1997)
passing user info on each page (2000)
ImageMagick and [shell] (2003)
Online Docs for the Beta... (2000)
Strange Form Occurrence on Log In Pages (2005)
setting a cookie for the whole server (2004)
NT Setup (1998)