<cfquery name="house_data" datasource="houses">
SELECT price, address, image_path, image_description
FROM tblHouses
</cfquery>

<CFOUTPUT QUERY="house_data">
Address: #address# Price: #price#
<img src="#image_path#" alt="#image_description#">
</CFOUTPUT>

Listing 2

<table summary="This table lists the artists and titles of my music collection"
border="1" >
<caption>C D collection</caption>
<tr>
<th id="artist">artist</th>
<th id="title">title</th>
</tr>
<CFLOOP QUERY="CD_collection" >
<CFOUTPUT>
<tr>
<td headers="artist">#artist#</td>
<td headers="title">#title#</td>
</tr>
</CFOUTPUT>
</CFLOOP>
</table>

Listing 3

<cfset numrows = 5>
<cfoutput>
<input type="hidden" name="numrows" value="#numrows#">
</cfoutput>
<TABLE>
<TR><td>Series</td><td>entity</td><td>start_date</td></tr>
<CFLOOP index="row" from="1" to="form.
<cfoutput>
<TR>
<td><CFINPUT TYPE="text" Name="Series_#row#"></td>
<td><CFINPUT TYPE="text" Name="entity_#row#"></td>
<td><cfinput type="Text" name="start_date_#row#"></td>
</tr>
</cfoutput>
</cfloop>
</table>
<input type="submit" name="submit" value="Submit Request">

Listing 4

<CFLOOP INDEX = "Counter" FROM = "1" TO = Form.numrows>
<CFIF
evaluate("FORM.SERIES_#COUNTER#") IS NOT "" AND
evaluate("FORM.ENTITY_#COUNTER#") IS NOT "" AND
evaluate("FORM.START_DATE_#COUNTER#") IS NOT "" >

Update or Insert record here
</cfif>
</cfloop>