<%Set np = Server.CreateObject("ADODB.Recordset") sor = "SELECT * FROM StarsManager where SM_ID=1" np.Open sor,conn,1,3 if np.bof or np.eof then else %> <%=np("SM_Detail")%> <%end if np.Close Set np = Nothing%>