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
      %>

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