中科新闻网食物助眠方法:如何ASP提取记录集保存到数组中
来源：百度文库 编辑：中科新闻网 时间：2024/04/25 18:52:27
如：sql="SELECT sum(h1),sum(h2),sum(h3),sum(h4),sum(h5),sum(h6),sum(h7),sum(h8),sum(h9),sum(h10),sum(h11),sum(h12),sum(h13),sum(h14),sum(h15),sum(h16),sum(h17),sum(h18),sum(h19),sum(h20),sum(h21),sum(h22),sum(h23),sum(h24) FROM tateltime WHERE tDay = '2006-5-17' and s.id='102'"
把这个要提取的值，sum(h1)....sum(h24)保存在一个数组里，然后通过读取数组的值进行调用？
把这个要提取的值，sum(h1)....sum(h24)保存在一个数组里，然后通过读取数组的值进行调用？
dim arr,i,sql
sql="SELECT sum(h1),sum(h2),sum(h3),sum(h4),sum(h5),sum(h6),sum(h7),sum(h8),sum(h9),sum(h10),sum(h11),sum(h12),sum(h13),sum(h14),sum(h15),sum(h16),sum(h17),sum(h18),sum(h19),sum(h20),sum(h21),sum(h22),sum(h23),sum(h24) FROM tateltime WHERE tDay = '2006-5-17' and s.id='102'"
set arr =conn.execute(sql)
for i = 0 to 23
response.write "sum(h"&i+1&") = "&arr(i)
next
试试