It looks like you are doing asp with vbscript - it that correct ? I have tested it and it works fine. Do you have vb - if so test it with vb. How are you connecting to the database - post your code leading up to the recordset. Which version of sql server are you using - which version of ado/asp are you using ? Can you just set one of the field values equal to amount ?
Thanks for the reply. Yes, you are right, I am using ASP with VBscript.
Version: SQL server 2000 & ASP3.0[IIS5.0].
Connection String: "Provider=SQLOLEDB;User ID=sa;password=xxx;Initial Catalog=myDb;Data Source=(local);"
sql="Select * from myTable"
if not rs.EOF then
Amt=rs("Rate")+rs("Interest") 'error in this line
Can you just set one of the field values equal to amount ?
What do you mean by this? I didn't get you.
More Info: I am looking for a solution that is related with SQL server, rather than ASP. [because if the solution is ASP related, then I may have to change a lot of forms - around 150]