ski4ever 0 Newbie Poster

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.