This should be pretty basic, but it's giving me a lot of trouble. I'm trying to add the values of Recordset1.Price1 and Recordset1.AdditionalCost in ASP JScript. Instead of adding the two values together, it put the two side by side. Here's the code I'm using....

<% var MyTotal = ((Recordset1.Fields.Item("Price1") + (Recordset1.Fields.Item("AdditionalCost")); %>

If Price is 2 and AdditionalCosts is 2, the result is 22, rather than 4.

Please help.
Thanks

Dear Contact,
Are they declared numeric fields in your db?

Regards,
Brent

Currency in MS Access

If you swap out the + sign, with a - sign, * sign, / sign... it works perfect. It just won't add. This is very fustrating.

Just try...

<% var MyTotal = 0 + ((Recordset1.Fields.Item("Price1") + (Recordset1.Fields.Item("AdditionalCost")); %>

Think it will work

Adding the "0 +", didn't seem to do anything. Thanks though.

Dear Contact,
Instead of the + symbol, try:

&&

or

|| (double-pipes, above the backslash)


Regards,
Brent

I have cosntructed similar code and mine work, try below:

<%
Dim MyTotal
MyTotal = 0
MyTotal = ((Recordset1.Fields.Item("Price1".Value)+(Recordset1.Fields.Item("AdditionalCost".Value))

It should give you 4 rather than 22

I hope this works for you.

Stewart

SORRY, last reply is wrong.

code should be:

<%
Dim MyTotal
MyTotal = ((Recordset1.Fields.Item("Price1".Value)+(Recordset1.Fields.Item("AdditionalCost".Value))
%>

Stewart

Try this...add .value :

<% var MyTotal = ((Recordset1.Fields.Item("Price1".value) + (Recordset1.Fields.Item("AdditionalCost".value)); %>

Doc
Rangewalk Digital Studios