% id=session("id") sql="select corporation.*,class_1.sort from corporation,class_1 where id="&id&" and class_1.sortid=corporation.sortid" Set rs= conn.execute(sql) if rs.eof then sql2="select corporation.* from corporation,class_1 where id=" & id Set rs2= conn.execute(sql) if rs2.eof then response.Redirect("../index.asp") response.end end if rs2.close set rs2=nothing else zycp=rs("zycp") pharry=split(rs("phone")," ") faarry=split(rs("fax")," ") %>
|
|