<% sqlQuery = "select * from tbl_IEEE_user u, tbl_IEEE_school s where u.USSCID = s.SCID and u.USID="&userToBeUpdated set RSbuffer = conn.execute(sqlQuery) if RSbuffer.eof = false then %>

Name :  <%=trim(RSbuffer("USFNAME"))&" "&trim(RSbuffer("USMNAME"))&" "&trim(RSbuffer("USLNAME"))%>
Email: "><%=trim(RSbuffer("USEMAIL"))%>
School: <%=trim(RSbuffer("SCNAME"))%>
Home phone: <%=trim(RSbuffer("USPHONEHOME"))%>
Work phone: <%=trim(RSbuffer("USPHONEWORK"))%>
Username: <%=trim(RSbuffer("USUSERNAME"))%>

<% sqlQuery = "select * from tbl_IEEE_approved_user where AUUSID="&cint(RSbuffer("USID")) set RSData2 = conn.execute(sqlQuery) if RSData2.eof = false then 'the user has been approved %> '" id=button3 name=button3> '" id=button2 name=button2> <% else ' the user has not been approved %> '" id=button3 name=button3> '" id=button4 name=button4> '" id=button1 name=button1> <% end if end if %>