shopping cart

[John Smith]

Hi,

I'm trying to work out the postage rate for products in a shopping cart.
Predictably there is no formula for working out the postage rate (ie. 0.20 *
weight). The problem i'm having is with the statement for working this out

There are different 'bands' for the weight (i.e. between 150g and 200g the
price is 0.50). What's the best way to write a statement for this ? I have
tried different ways of writing an If statement but they all end up in
chaos.

John

[Aaron Bertrand - MVP]

Re: shopping cart

Use a database table. Assuming SQL Server:



CREATE TABLE postageRates
(
weightlowerboun d INT,
weightupperboun d INT,
rate DECIMAL(19,2)
)

INSERT postageRates VALUES(0, 149, 0.25)
INSERT postageRates VALUES(150, 200, 0.50)
INSERT postageRates VALUES(201, 500, 0.85)
-- ...

DECLARE @weight INT
SET @weight = 172
SELECT rate FROM postageRates
WHERE @weight
BETWEEN weightlowerboun d AND weightupperboun d

DROP TABLE postageRates



You could also do this within an array in ASP...



"John Smith" <john@nospam.sp am> wrote in message
news:beken4$pi4 $1@titan.btinte rnet.com...[color=blue]
> Hi,
>
> I'm trying to work out the postage rate for products in a shopping cart.
> Predictably there is no formula for working out the postage rate (ie. 0.20[/color]
*[color=blue]
> weight). The problem i'm having is with the statement for working this out
>
> There are different 'bands' for the weight (i.e. between 150g and 200g the
> price is 0.50). What's the best way to write a statement for this ? I have
> tried different ways of writing an If statement but they all end up in
> chaos.
>
> John
>
>[/color]

[John Smith]

Re: shopping cart

works great, thanks !


"Aaron Bertrand - MVP" <aaron@TRASHasp faq.com> wrote in message
news:%23Kt3stxR DHA.3192@TK2MSF TNGP10.phx.gbl. ..[color=blue]
> Use a database table. Assuming SQL Server:
>
>
>
> CREATE TABLE postageRates
> (
> weightlowerboun d INT,
> weightupperboun d INT,
> rate DECIMAL(19,2)
> )
>
> INSERT postageRates VALUES(0, 149, 0.25)
> INSERT postageRates VALUES(150, 200, 0.50)
> INSERT postageRates VALUES(201, 500, 0.85)
> -- ...
>
> DECLARE @weight INT
> SET @weight = 172
> SELECT rate FROM postageRates
> WHERE @weight
> BETWEEN weightlowerboun d AND weightupperboun d
>
> DROP TABLE postageRates
>
>
>
> You could also do this within an array in ASP...
>
>
>
> "John Smith" <john@nospam.sp am> wrote in message
> news:beken4$pi4 $1@titan.btinte rnet.com...[color=green]
> > Hi,
> >
> > I'm trying to work out the postage rate for products in a shopping cart.
> > Predictably there is no formula for working out the postage rate (ie.[/color][/color]
0.20[color=blue]
> *[color=green]
> > weight). The problem i'm having is with the statement for working this[/color][/color]
out[color=blue][color=green]
> >
> > There are different 'bands' for the weight (i.e. between 150g and 200g[/color][/color]
the[color=blue][color=green]
> > price is 0.50). What's the best way to write a statement for this ? I[/color][/color]
have[color=blue][color=green]
> > tried different ways of writing an If statement but they all end up in
> > chaos.
> >
> > John
> >
> >[/color]
>
>[/color]