Hi People,
I've got this bit of code that shows all my records
on an asp page fine, so now I want to add a total at the bottom. I try to add a field to a variable inside the loop but always get zero for the total for some reason. Is there a better way, there doesnt seem to be a method for this????
Thanks
;-)
<%dim total
total=0
do until OracRS.eof%>
<tr> <td>£<%=oracrs.fields.item("nbc_premium"%></td>
</tr>
<%total=total+oracrs.Fields("nbc_premium".Value
OracRS.MoveNext
loop
Response.Write(total)%>
I've got this bit of code that shows all my records
on an asp page fine, so now I want to add a total at the bottom. I try to add a field to a variable inside the loop but always get zero for the total for some reason. Is there a better way, there doesnt seem to be a method for this????
Thanks
;-)
<%dim total
total=0
do until OracRS.eof%>
<tr> <td>£<%=oracrs.fields.item("nbc_premium"%></td>
</tr>
<%total=total+oracrs.Fields("nbc_premium".Value
OracRS.MoveNext
loop
Response.Write(total)%>