Code:
<!-- #include file="connection.inc"-->
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
</HEAD>
<BODY>
<FORM NAME=f1 METHOD=post ACTION=errlog.ASP>
<%
set rs1=server.CreateObject("adodb.recordset")
%>
<P>MODULE REF <SELECT id=c name=c onchange=window.f1.submit();>
<option value=1>LOCKER</option>
<OPTION value=2>BAGIC</option>
<option value=3>MF</option>
</SELECT>
</P>
<%
if(c=1) then
sql1="select MODULE_ID,BR_LOGIN_USER,ACTION_PERFORMED,ACTION_TIME,MODULE_REMARKS from FRS_AUDIT_LOG@frsutil where MODULE_ID LIKE '"+LOCKER+"'"
rs1.Open sql1,conn
else if(c=2) then
sql1="select MODULE_ID,BR_LOGIN_USER,ACTION_PERFORMED,ACTION_TIME,MODULE_REMARKS from FRS_AUDIT_LOG@frsutil where MODULE_ID LIKE '"+BAGIC+"'"
rs1.Open sql1,conn
else if(c=3)then
sql1="select MODULE_ID,BR_LOGIN_USER,ACTION_PERFORMED,ACTION_TIME,MODULE_REMARKS from FRS_AUDIT_LOG@frsutil where MODULE_ID LIKE '"+MUTUAL_FUND+"'"
rs1.Open sql1,conn
else
sql1="SELECT sysdate from dual"
rs1.Open sql1,conn
%>
<TABLE border=1>
<TR style="COLOR: darkgreen">
<td><p align=center><b><FONT size=4>MODULE</b></FONT><p></p></td>
<td><P align=center><B><FONT size=4>USER </B></FONT></P></td>
<td><P align=center><B><FONT size=4>ACTION</B></FONT></P></td>
<td><P align=center><B><FONT size=4>TIME</B></FONT></P></td>
<td><P align=center><B><FONT size=4>REMARKS</B></FONT></P></td></TR>
<%
do until rs1.eof
%>
<tr>
<TD><%Response.Write rs1(0)%></TD>
<TD><%Response.Write rs1(1)%></TD>
<TD><%Response.Write rs1(2)%></TD>
<TD><%Response.Write rs1(3)%></TD>
<TD><%Response.Write rs1(4)%></TD>
<%
rs1.movenext
loop
rs1.close
end if
end if
end if
%></tr>
</TABLE>
</FORM>
</BODY>
</HTML>
error occured:Item cannot be found in the collection corresponding to the requested name or ordinal. "i checked query its correct i feel in program flow may be error occur"
Comment