SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 3.

Question

topic_list表，字段顺序为：boardID,topicAuthor,topicTittle,topicContent,istop,createdTime,reply_num,read_num,lastModifiedTime,lastReplyer,topicID源代码如下(部分):<tr> 
    <td ><a href="tiezi_chakan.jsp?boardID=<%=boardID%>&topicID=<%=topicID%>"><%=rs.getString("topicTittle")%></a> </td>
    <td > <%=rs.getString("topicAuthor")%></td>
    <td ><%="" + rs.getInt("reply_num") + "/" + rs.getInt("read_num")%></td>
    <td ><%=rs.getString("lastModifiedTime")%> </td>
    <td ><%=rs.getString("lastReplyer")%> </td>
  </tr>难道真的要严格按照顺序吗,为什么sqlserver和access不一样啊？

Answer 1

sqlserverjdbc在select的列中包含text或image字段时，须按select的列顺序读取