% openconn sqlp="select top 1 * from product where P_Language=2 and P_New=1 order by P_order asc" set rsp=server.CreateObject("adodb.recordset") rsp.open sqlp,conn,1,1 If Not rsp.eof Then P_Content=rsp("P_Wap") Pic=rsp("P_Field3") Pid=rsp("P_id") PSortid=rsp("P_Sortid") End If rsp.close set rsp=nothing sqln="select top 1 * from news where N_Language=2 and N_special=1 order by N_order asc" set rsn=server.CreateObject("adodb.recordset") rsn.open sqln,conn,1,1 If Not rsn.eof Then n_Content=rsn("N_Name") nPic=rsn("N_Pic") nid=rsn("N_id") End If rsn.close set rsn=nothing %>
|
||||||||||||||||||||||||||||||||