I am listing DB values inserted from checkbox selections. http://amftrb.org/examApp_detail.cfm is set up to display 10 rows. In the first 10 rows of the DB there are 8 winxp entries for the OS variable. The page displays the 8 of 10 records that have winxp. Is there a way to have the page display 10 records that contain winxp? The first WinXP column has 9 entries; the second column has 8 entries. It appears that, for example, the first 10 rows are being checked and only the nine of ten records with a winxp entry are being displayed. Similarly, only the eight of ten records in records 11-20 are being displayed.
Code for the Operating System: WinXP row:
<!--- OS: Windows XP --->
<tr class="padBorderBottom">
<td><div align="right">Windows XP:</div></td>
<cfoutput>
<td><div align="right"><span class="outputList">#ListValueCount(ValueList(qGetExamApp.os), "os_winxp")#</span></div></td>
</cfoutput>
<td>
<cfset Start = 1>
<cfset End = 10>
<cfoutput query="qGetExamApp" startrow="#Start#" maxrows="10">
<cfif ListContains(os, "os_winxp")>
<span class="outputList"><strong>#state#<br /></strong></span>
</cfif>
</cfoutput>
</td>
<td>
<cfset Start = 11>
<cfset End = 20>
<cfoutput query="qGetExamApp" startrow="#Start#" maxrows="10">
<cfif ListContains(os, "os_winxp")>
<span class="outputList"><strong>#state#<br /></strong></span>
</cfif>
</cfoutput>
</td>
<td>
<cfset Start = 21>
<cfset End = 30>
<cfoutput query="qGetExamApp" startrow="#Start#" maxrows="10">
<cfif ListContains(os, "os_winxp")>
<span class="outputList"><strong>#state#<br /></strong></span>
</cfif>
</cfoutput>
</td>
<td>
<cfset Start = 31>
<cfset End = 40>
<cfoutput query="qGetExamApp" startrow="#Start#" maxrows="10">
<cfif ListContains(os, "os_winxp")>
<span class="outputList"><strong><strong>#state#</strong><br />
</strong></span>
</cfif>
</cfoutput>
</td>
</tr>
Thanks in advance for any assistance you can provide.
Larry Porter