This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / 熟悉SQL Server和ADO的大侠进来看看
-johnnyhatesjazz(Rock and Roll);
2005-5-27
{1002}
(#2316367@0)
-
sp_helprotect might have empty results. before you do any loop, check if the recordset is null or nothing first.
-ningxin0809(雁影行洲);
2005-5-27
(#2316389@0)
-
这个问题想到过了。但好像不是。每次出错是在Do until vDBSet.eof时候出的错。做了个判断，vDBset这个recordset居然在vDBSet.open sqlstring, dbCon 之后是null。就是说没有任何东西回来。真是奇怪。
-johnnyhatesjazz(Rock and Roll);
2005-5-30
(#2319746@0)
-
wscript.echo CStr(vDBSet.Fields.(j).Name)?
-23456789(大白呼);
2005-5-28
(#2317355@0)
-
这个问题解决了。for each vName in dbrecordset.fields wscript.echo vName.name next
-johnnyhatesjazz(Rock and Roll);
2005-5-30
(#2319743@0)