7,714
社区成员
发帖
与我相关
我的任务
分享
sql_list="select * from [god_blood] where (a="rs_comp("a")")+ (b="rs_comp("b")")+ (c="rs_comp("c")")+(d="rs_comp("d")")+(e="rs_comp("e")")+(f="rs_comp("f")")<=-3 and id<>"comp_id" "
sql_list="select * from god_blood where(a=" _
& rs_comp("a") & ")+ (b=" _
& rs_comp("b") & ")+ (c=" _
& rs_comp("c") & ")+(d=" _
& rs_comp("d") & ")+(e=" _
& rs_comp("e") & ")+(f=" _
& rs_comp("f") & ")<=-3 "
Set rslist=Server.CreateObject("adodb.recordset")
sql_list="select * from god_blood where(a="rs_comp("a")")+ (b="rs_comp("b")")+ (c="rs_comp("c")")+(d="rs_comp("d")")+(e="rs_comp("e")")+(f="rs_comp("f")")<=-3 "
rslist.open sql_list,conn,1,1