redefined the names

[meenakshidhar]

my code is given below..i have two recordsets named "rs" both..
the error which i m getting is
---------------------------------------------
Microsoft VBScript compilation error '800a0411'

Name redefined

/test/db.asp, line 36

dim rs
----^
---------------------------------------------
so can't i redefined the name in asp??? is there any way to redefine the names...


<%@ Language=VBScript %>
<%Option explicit%>
<!-- #include file="connection.asp" -->
<%
dim rs
set rs=server.CreateObject("adodb.recordset")
set rs=conn.Execute("select * from invoice")
Response.write rs("invoicenumber")
rs.close
set rs=nothing


dim rs
set rs=server.CreateObject("adodb.recordset")
set rs=conn.Execute("select * from CustomerUsage where anicode='aaa'")
response.write rs("CompanyName") & "<br>"
rs.close
set rs=nothing
%>

 

[FesterSXS]

You dont need to redefine it. Get rid of the second definition and you will be OK. However, good programming practice would say that you shouldn't use the same name twice.


Tony

http://www.SpiraxSarco.com

 

[meenakshidhar]

thanks a lot FesterSXS...