28,390
社区成员
发帖
与我相关
我的任务
分享
Set rsCheck=Server.CreateObject("ADODB.RecordSet")
strsql="select ID,Name,Score,Price2,price1,amount,VipPrice,Stock,solded from Product where ID in order by ID"
rsCheck.open strsql,conn,1,3
Do While Not rsCheck.EOF
%>
<%=rsCheck("name")%>
<%=rsCheck("id")%>
,这里是数据循环输出
<%
rsCheck.MoveNext
Loop
<%
......
Do While Not rsCheck.EOF
dim x,e
x=x&rsCheck("name")&"," '用逗号分开.
%>
<%=rsCheck("name")%>
<%=rsCheck("id")%>
,这里是数据循环输出
<%
rsCheck.MoveNext
Loop
e=left(x,(len(x)-1)) '这里是变量e取得的值
....
%>