28,390
社区成员
发帖
与我相关
我的任务
分享请教数组出错问题
for i=1 to 7
classroom(i)=i
studentid=gradechoose+i
temSQL(i)="Select max(CDbl("&subjectname&")) as maxcount(i),min(CDbl ("&subjectname&")) as mincount(i) From stugrade where year="&yearchoose&"and tearm="&tearmchoose&"and num="&numchoose&"and studentid like '"&studentid&"%'"
Set temrs(i)=Server.CreateObject("ADODB.RecordSet")
temrs(i).Open temSQL(i),conn,3,2
next
temrs(i).Open temSQL(i),conn,3,2 这一行出错，请指教原因，
temrs和temsql能不能用数组？？？
classroom(i)=i
studentid=gradechoose+i
temSQL(i)="Select max(CDbl("&subjectname&")) as maxcount(i),min(CDbl ("&subjectname&")) as mincount(i) From stugrade where year="&yearchoose&"and tearm="&tearmchoose&"and num="&numchoose&"and studentid like '"&studentid&"%'"
Set temrs(i)=Server.CreateObject("ADODB.RecordSet")
temrs(i).Open temSQL(i),conn,3,2
next
temrs(i).Open temSQL(i),conn,3,2 这一行出错，请指教原因，
temrs和temsql能不能用数组？？？
...全文
请发表友善的回复…
发表回复
qunluo 2003-10-15
- 打赏
- 举报
gz
angelheavens 2003-10-15
- 打赏
- 举报
改成:temrs(i).Open temSQL(i),conn,1,1试试,下面是我测试的代码,可以:
<!--#include file="conn.asp" -->
<%
dim rsa(5),sqla(5)
for i=0 to 4
sqla(i)="select * from table1"
Set rsa(i)=Server.CreateObject("ADODB.RecordSet")
rsa(i).open sqla(i),conn,1,1
next
%>
(如果有疑问,请发短信息来相互讨论)
<!--#include file="conn.asp" -->
<%
dim rsa(5),sqla(5)
for i=0 to 4
sqla(i)="select * from table1"
Set rsa(i)=Server.CreateObject("ADODB.RecordSet")
rsa(i).open sqla(i),conn,1,1
next
%>
(如果有疑问,请发短信息来相互讨论)
