Practice with asp
<%
'Get the variable from the querystring.
'Build the SQL statement, making sure to surround the text
'field "email" with single quotes
SQL="SELECT LName, FName, city.name FROM "
SQL = SQL & "people INNER JOIN city "
SQL = SQL & "on people.city = city.id"
'Create connection named "conn"
'Load the resulting recordset into the variable rs
set conn = server.createobject("ADODB.Connection")
conn.open "practiceSystem"
conn.execute("delete from people where LName = 'Gordon'")
conn.execute("insert into people values ('Gordon', 'Jeff', 2)")
set rs =conn.execute(SQL)%>
<%
do while not rs.eof %>
| <%=rs(0)%> |
<%=rs(1)%> |
<%=rs(2)%> |
<%
rs.moveNext
loop
conn.close
%>