|
Subject:
|
Exception Occured (0x80020009) problem
|
|
Posted By:
|
dominic_huang
|
Post Date:
|
11/16/2004 8:23:07 PM
|
Guys,
When I tried to use the data in my database to build a dvd list table, this problem. I had no problem when I did with catalog ID 1 and catalog ID 2, but I don't know the reason when I try to do with catalog ID 3, this problem happens.....Could someone help me....Thanks.
<%
'Build Recordset
set oRS = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT * FROM dvd WHERE catalogID=3;"
oRS.Open SQL, conn
intCounter = 1
Do While oRS("catalogID")=3 And NOT oRS.EOF
%>
<tr>
<td align="center"><%=oRS("dvd_id")%></td>
<td><a href="Moviedetail.asp?intdvd_id=<%=oRS("dvd_id")%>"> <%=oRS("dvd_title")%></a></td>
<td align="right"><%=oRS("price")%></td></td></tr>
<%
oRS.MoveNext
intCounter = intCounter + 1
Loop
%>
|
|
Reply By:
|
om_prakash
|
Reply Date:
|
11/17/2004 12:13:59 AM
|
Instead this can be:
<%
'Build Recordset
set oRS = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT * FROM dvd WHERE catalogID=3;"
oRS.Open SQL, conn
intCounter = 1
Do While NOT oRS.EOF
%>
<tr>
<td align="center"><%=oRS("dvd_id")%></td>
<td><a href="Moviedetail.asp?intdvd_id=<%=oRS("dvd_id")%>"> <%=oRS("dvd_title")%></a></td>
<td align="right"><%=oRS("price")%></td></td></tr>
<%
oRS.MoveNext
intCounter = intCounter + 1
Loop
%>
Because already there is condition above in the SQL query.
Om Prakash
|
