Here is the code for name.htf
<html>
<head>
{set page %theArgs% 'thename' containsAnyString:}
{if page false =}
{set thename 'nope'}
{/if}
{sql to answers source 'steva' user 'steva' password 'eva'}
Select * from exercise2 where name = '{ thename }'
{/sql}
{if 0 answers size = }
<title>Error</title>
</head>
<body>
<h2>Sorry no results were returned for { thename }. Please try again
and check to make sure the name is properly spelled(caps counts).</h2>
<a href = "http://www.cs.pitt.edu/~hopeman/webbasexample.html">Return to Examples</a>
{else}>
<title>Success!</title>
</head>
<body>
<table align = center>
<tr>
<td>Name</td>
<td>SSN</td>
<td>Mod</td>
<td>CompDate</td>
<td>grade</td>
</tr>
{forRow currRow on answers}
<tr>
<td>{ NAME }</td>
<td>{ SSN }</td>
<td>{ MOD }</td>
<td>{ COMPDATE }</td>
<td>{ GRADE }</td>
</tr>
{/forRow}
</table>
<table align = center>
<a href = "http://www.cs.pitt.edu/~hopeman/webbasexample.html">Return to Examples</a>
</table>
{/if}
</body>
</htmL>