js内如何循环asp数据

Question

<script type="text/javascript">
 
 var picsJson={"pics":[
<% dim abc
set rs3=server.CreateObject("ADODB.RecordSet")
rs3.Source="select * from xxx "
rs3.Open rs3.Source,conn,1,1 
do While Not Rs3.Eof
abc=rs3("picname")
end if
%>
{"thumbPicUrl":"<%= abc %>","middlePicUrl":"<%= abc %>"}
<%
rs3.MoveNext
loop
rs3.close
set rs3=nothing
%>
]}; </script>

Answer 1

还是不显示图片，请高手给修改一下<script type="text/javascript">
var picsJson={"pics":[<%
dim abc,fileext
set rs3=server.CreateObject("ADODB.RecordSet")
rs3.Open "select * from xxx",conn,1,1 
do While Not rs3.Eof
   abc=trim(rs3("picname"))
   fileext=right(abc,3)
   if fileext="jpg" or fileext="bmp" or fileext="png" or fileext="gif" then
   %>{"thumbPicUrl":"<%= abc %>","middlePicUrl":"<%= abc %>"}，//这里还有个逗号
<%
   end if
   rs3.MoveNext
loop
rs3.close
set rs3=nothing
%>]};
</script>

Answer 2

原始的js是这样的,循环中间的部份
var picsJson={"pics":[
{"thumbPicUrl":"/132/img/zp01.jpg","bigPicUrl":"/132/img/zp01.jpg":"/132/img/zp01.jpg"},
{"thumbPicUrl":"/132/img/zp02.jpg","bigPicUrl":"/132/img/zp02.jpg":"/132/img/zp02.jpg},{"thumbPicUrl":"/132/img/zp03.jpg","bigPicUrl":"/132/img/zp03.jpg":"/132/img/zp03.jpg"}
]};

Answer 3

<script type="text/javascript">
var picsJson={"pics":[<%
dim abc,fileext
set rs3=server.CreateObject("ADODB.RecordSet")
rs3.Open "select * from xxx",conn,1,1  
do While Not rs3.Eof
  abc=trim(rs3("picname"))
  fileext=right(abc,3)
  if fileext="jpg" or fileext="bmp" or fileext="png" or fileext="gif" then
  %>
<% 
在這裏再加一個判斷，判斷結果集的size
 %>
{"thumbPicUrl":"<%= abc %>","middlePicUrl":"<%= abc %>"}，//这里<%%>
<%
  end if
  rs3.MoveNext
loop
rs3.close
set rs3=nothing
%>]};
</script>