Here is the table structure
CREATE TABLE [tblProducts] (
[productid] [int] IDENTITY (3426, 1) NOT NULL ,
[productdescript ionid] [int] NULL ,
[subgroupid] [int] NULL ,
[productcode] [nvarchar] (255) COLLATE Latin1_General_ CI_AS NULL ,
[pcksize] [nvarchar] (100) COLLATE Latin1_General_ CI_AS NULL ,
[distributordist _percent] [nvarchar] (50) COLLATE Latin1_General_ CI_AS NULL
,
[distributor_cos t_pounds] [char] (50) COLLATE Latin1_General_ CI_AS NULL ,
[description] [nvarchar] (255) COLLATE Latin1_General_ CI_AS NULL ,
[distributorpric e] [decimal](18, 2) NULL ,
[unitprice] [decimal](18, 2) NULL ,
[disc4] [decimal](18, 2) NULL ,
[disc10] [decimal](18, 2) NULL ,
[disc20] [decimal](18, 2) NULL ,
[weight] [decimal](18, 2) NULL ,
[specialoffer] [bit] NULL CONSTRAINT [DF_tblProducts_ specialoffer] DEFAULT
(0),
[add_description] [varchar] (2000) COLLATE Latin1_General_ CI_AS NULL ,
[graphic] [varchar] (200) COLLATE Latin1_General_ CI_AS NULL ,
[rank] [int] NULL ,
CONSTRAINT [PK_tblProducts] PRIMARY KEY CLUSTERED
(
[productid]
) ON [PRIMARY] ,
CONSTRAINT [FK_tblProducts_ tblProductDescr iptions] FOREIGN KEY
(
[productdescript ionid]
) REFERENCES [tblProductDescr iptions] (
[productdescript ionid]
) ON DELETE CASCADE
) ON [PRIMARY]
GO
This is an email produced as part of a shopping cart system.
In the ASP the idea is if you are logged in as one type of user you get a
distributor price, alternatively you can a different price depending on the
quantity selected. The price variable works well in the various calculations
its just when I format it or concatenate too much. The outputted string is
wrong not the underlying variable. The problem which I replicate is a the
first attempt to format price pulled from the distributor price value in the
recordset.
There is a lot of code here but.....
for each cookiekey in request.cookies ("productid" )
Key = "key" & i
productid = request.cookies ("productid")(k ey)
rsRecordset.Mov eFirst
rsRecordset.Fin d "productid =" & productid
qty = request.cookies ("qty")(key)
if isnull(rsRecord set("expirydate ")) then
expirydate = date
else
expirydate = cdate(rsRecords et("expirydate" ))
end if
if rsRecordset("sp ecialoffer") <> 0 and date < expirydate then
prodcode = rsRecordset("of fercode")
else
prodcode = rsRecordset("pr oductcode")
end if
if rsRecordset("sp ecialoffer") <> 0 and date < expirydate then
prodcode = rsRecordset("of fercode")
else
prodcode = rsRecordset("pr oductcode")
end if
if rsRecordset("sp ecialoffer") <> 0 and date < expirydate then
price = cdbl(rsRecordse t("price"))
else
if role = "2" then
'displayprice = "test" & formatcurrency( cdbl(price))
price = rsRecordset("di stributorprice" )
else
if qty < 5 then
price = csng(rsRecordse t("unitprice" ))
elseif qty > 4 and qty < 11 then
price = csng(rsRecordse t("disc4"))
elseif qty > 10 and qty < 21 then
price = csng(rsRecordse t("disc10"))
else
price = csng(rsRecordse t("disc20"))
end if
if price = 0 then
price = csng(rsRecordse t("disc10"))
end if
'response.write price
if price = 0 then
price = csng(rsRecordse t("disc4"))
'response.write price
end if
if price = 0 then
price = csng(rsRecordse t("unitprice" ))
'response.write "test"
end if
end if
end if
subtotal = cdbl(price) * cdbl(qty)
total = subtotal + total
if isnull(rsRecord set("weight")) then
weight = 0
else
weight = cdbl(rsRecordse t("weight"))
weight = weight * cdbl(qty)
end if
totalweight = weight + totalweight
HTML = HTML & "<td>" & prodcode & "</td>"
HTML = HTML & "<td>" & qty & "</td>"
'IT IS WHEN I TRY TO FORMAT THE PRICE VARIABLE IN THIS BIT
HTML = HTML & "<td>" & price & "(€" & formatnumber(pr ice*rate,2) & ")"
& "</td>"
HTML = HTML & "<td>" & weight & " kg</td>"
HTML = HTML & "<td>" & formatcurrency( subtotal) & "(€" &
formatnumber(su btotal*rate,2) & ")" & "</td>"
HTML = HTML & "</tr>"
weight = 0
price = 0.0
i = i + 1
next
"Aaron [SQL Server MVP]" <te*****@dnartr eb.noraa> wrote in message
news:OJ******** ********@tk2msf tngp13.phx.gbl. ..
Any ideas.
Only if you show your table structure, sample data, ASP code, and desired
results.
--
http://www.aspfaq.com/
(Reverse address to reply.)
