为什么，这个sql语句的字段位置换下，读记录集字段内容的时候就说 [Microsoft][ODBC SQL Server Driver]无效的描述符索引

[peterpansh]

数据库使用 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

错误说明: [Microsoft][ODBC SQL Server Driver]无效的描述符索引
错误地点:urldomain = rs.getString("urldomain");



发送错误时候的sql(只是吧tblsearchurl.urldomain 放到最前面):

sql = "select top 1 tblsearchurl.urldomain , tblsearchurl.id_pk, tblurlext.urlid_pk,tblurlext.id_fk, tblurlext.url as urlext, tblsearchurl.url as url1 from tblurlext ,tblsearchurl where tblurlext.isread=0 and tblurlext.id_fk=tblsearchurl.id_pk ";

正确的时候的sql:
sql = "select top 1 tblsearchurl.id_pk, tblurlext.urlid_pk,tblurlext.id_fk, tblurlext.url as urlext, tblsearchurl.url as url1,tblsearchurl.urldomain from tblurlext ,tblsearchurl where tblurlext.isread=0 and tblurlext.id_fk=tblsearchurl.id_pk ";

把sql放到查询分析器里运行没有问题。
不知道为什么，实在想不通。

[zhakeer]

JdbcOdbcDriver是jdbc1.0标准，读取顺序必须和查询顺序一样

[peterpansh]

谢谢！