Cold Fusion Workshop: Building on the First Example

Cold Fusion Workshop:
Building on the First Example

Adding some static HTML:

<BODY BGCOLOR="#FFFFCC">

<CENTER>
<H1>Complete List of People<BR>
(Sorted by Lastnames)</H1>
<CENTER>
<BR>

Putting the output in a table:

<TABLE CELLPADDING="8" >

<CFOUTPUT QUERY="njerpQuery">
         <TR>
                  <TD>#Lastname#</TD>
                  <TD>#Firstname#</TD>
                  <TD>#Organization#</TD>
         </TR>
</CFOUTPUT>

</TABLE>

Displaying the last name and the first name in a single column:

<TABLE CELLPADDING="8" >

<CFOUTPUT QUERY="njerpQuery">
         <TR>
                  <TD>#Lastname#, #Firstname#</TD>
                  <TD>#Organization#</TD>
         </TR>
</CFOUTPUT>

</TABLE>

Sorting the results alphabetically by last names:

<CFQUERY NAME="njerpQuery" DATASOURCE="njerp">
SELECT * from contacts
ORDER BY Lastname
</CFQUERY>

Creating a search form on the main page:

<FORM ACTION="PeopleList_Selected.CFM" METHOD="POST">
         <P>Search for a person: </P>

         <CENTER>
         <TABLE>
                  <TR>
                           <TD ALIGN="right"><B><FONT SIZE="3">Person's Lastname:</FONT></B></TD>
                           <TD><INPUT Type="text" NAME="Lastname" SIZE="50" MAXLENGTH="50"></TD>
                  </TR>
         </TABLE>

         <INPUT Type="submit" VALUE="Search">
         <INPUT Type="reset" VALUE="Clear Form">
         </CENTER>

</FORM>

Getting the results for the query:

<CFQUERY NAME="njerpQuery" DATASOURCE="njerp">
         SELECT * from contacts
         WHERE Lastname = '#Lastname#'
         ORDER BY Lastname
</CFQUERY>

Pattern matching on the character string:

<CFQUERY NAME="njerpQuery" DATASOURCE="njerp">
         SELECT * FROM contacts
         WHERE Lastname LIKE '#Lastname#%'
         ORDER BY Lastname
</CFQUERY>

Adding Comments:

Conditional Statements:

<CFIF #njerpQuery.recordcount# IS 0>
<P> Sorry, no matches were found for your query</P>
<CFELSE>

         <TABLE CELLPADDING="8" >

         <CFOUTPUT QUERY="njerpQuery">
                  <TR>
                           <TD>#Lastname#, #Firstname#</TD>
                           <TD>#Organization#</TD>
                  </TR>
         </CFOUTPUT>

         </TABLE>

</CFIF>