dim sql,json,rs sql="select top 5 id,s_name,s_addr,s_price,s_tel,s_tag0,s_tag1,s_tag2,s_tag3,gps,s_imgid from shop_list order by rnd(id)" set rs=conn.execute(sql) json="{" json=json&"""data"": [" While Not rs.EOF s="{" s = s&"""s_id"":""" & rs(0) & """," s = s&"""s_name"":""" & rs(1) & """," s =s&"""s_addr"":""" & rs(2) & """," s =s&"""s_price"":""" & rs(3) & """," s =s&"""s_tel"":""" & rs(4) & """," s =s&"""s_class"":""" & Get_Tag(rs(5)) & """," s =s&"""s_tag1"":""" & Get_Tag(rs(6)) & """," s =s&"""s_tag2"":""" & Get_Tag(rs(7)) & """," s =s&"""s_tag3"":""" & Get_Tag(rs(8)) & """," s =s&"""s_gps"":""" & rs(9) & """," s =s&"""s_img"":""" &Get_Shop_All_img(rs(10))& """" s=s&"}" json = json & s & "," rs.MoveNext Wend If Right(json,1) = "," Then json = Left(json,Len(json)-1) End If json = json & "]" json = json & "}" response.Write(json)