<CFQUERY NAME="njerpQuery" DATASOURCE="njerp">
SELECT * FROM Contacts
<CFIF ParameterExists(form.lastname) IS "yes">
WHERE Lastname LIKE '#Lastname#%'
</CFIF>
ORDER BY Lastname
</CFQUERY>
<HTML>
<HEAD>
<TITLE>List of people</TITLE>
</HEAD>
<BODY BGCOLOR="#CFD5EF">
<CENTER><H1>List of People</H1>
<P><B>(Sorted by Last names)</B></P></CENTER>
<BR>
<BR>
<BR>
<CFIF #njerpQuery.recordcount# IS 0>
<CENTER><P> Sorry, no matches were found for your query.</P></CENTER>
<CFELSE>
<CENTER>
<TABLE Cellpadding="5" WIDTH="100%">
<TR>
<TD colspan="2"><HR></TD>
</TR>
<CFOUTPUT QUERY="njerpQuery">
<TR>
<TD WIDTH="30%"><A HREF="secondExample_individualOutput.cfm?ContactID=#ContactID#">#Lastname#, #Firstname#</A></TD>
<TD>#Organization#</TD>
</TR>
<TR>
<TD COLSPAN="2"><HR></TD>
</TR>
</CFOUTPUT>
</TABLE>
</CENTER>
</CFIF>
</BODY>
</HTML>