28,391
社区成员
发帖
与我相关
我的任务
分享数据库查询结果发布到网页问题......
怎样才能让数据库查询结果的多条记录自动换行发布到网页上啊？？？！！！！我怎么不行啊！
StrSql2 = "select top 3 * from Snake_ann order by annid DESC"
Set rs4 = Conn.Execute(StrSql2)
StrHtml4 =rs4("title")
response.write StrHtml4
这样网页上只显示一条记录啊
StrSql2 = "select top 3 * from Snake_ann order by annid DESC"
Set rs4 = Conn.Execute(StrSql2)
StrHtml4 =rs4("title")
response.write StrHtml4
这样网页上只显示一条记录啊
...全文
请发表友善的回复…
发表回复
wansai00 2006-01-18
- 打赏
- 举报
c
KimSoft 2006-01-18
- 打赏
- 举报
StrSql2 = "select top 3 * from Snake_ann order by annid DESC"
Set rs4 = Conn.Execute(StrSql2)
while not rs4.eof
response.write =rs4("title")
rs4.movenext
wend
rs4.close
set rs4 = nothing
Set rs4 = Conn.Execute(StrSql2)
while not rs4.eof
response.write =rs4("title")
rs4.movenext
wend
rs4.close
set rs4 = nothing
hglwy 2006-01-18
- 打赏
- 举报
你得循环呀
do while not rs4.eof
response.write rs4("title")
response.write "<br>"
rs4.movenext
loop
do while not rs4.eof
response.write rs4("title")
response.write "<br>"
rs4.movenext
loop
Snakesnoop 2006-01-18
- 打赏
- 举报
多谢高手指点！！
