trying to add numbers in a recordset

[Andrew Thomas]

I have the following code

<% total=total+Clng(rs_orderlines("Value")) %>
<% Response.write(total)%>

which should add the field "value" and give a total.

but i get this error :

error '80020009'
Exception occurred.

value is type 'Number' in access database

thanks

Andrew

[txbakers]

shouldn't that be "CINT" instead of "CING"?

[wardbekker]

Clng is also valid, that's a convert to long int. Before executing this statement, check if the variable is a number with IsNumeric(var)

[txbakers]

hee hee - that was "LNG" then. It looked like "ING"

darn computer typefaces.

[Andrew Thomas]

Still get the same error, ive now changed the data type in the access database to currency, but it makes no difference.

any ideas

[Andrew Thomas]

found the problem: i put

<%total=total+(rs_orderlines.Fields.Item("Value").Value)%>

and it worked.

thanks

[txbakers]

Ah yes. Deceptive Javascript valuations of a variable.

I run into the same problem....sometimes. When you need an exact value of the variable you need to spell out the whole rsRecordSet.Fields.Item("").Value.

this crops ups with me mostly with strings where, like in Java, a static string doesn't necessarily "equal" the database variable. In java we would use the ".equals" method of the variable instead of the equality operator (==) to check for matches.

I don't know fully why you need to do this in ASP/JS but I do know to check that sometimes.