1 Reply Latest reply on Oct 14, 2006 1:11 PM by Shane930

    Master detail page set problems

    Shane930
      Hi, in using the master detail page set wizard in DW MX and CF 7, I found a problem I am unable to fix. The first page in the Master page shows up fine but when I use the "next" button it displays no records. I have found that none of the paging buttons work to display records. I was wondering if there was a known bug or problem with this master detail page set wizard.

      Here is my code:

      <cfparam name="FORM.vehicle_type" default="1">
      <cfparam name="FORM.vehicle_yearup" default="">
      <cfparam name="FORM.vehicle_yeardown" default="">
      <cfparam name="URL.recordID" default="1">
      <cfparam name="URL.ad_id" default="1">
      <cfparam name="FORM.model" default="1">
      <cfparam name="FORM.ad_id" default="1">
      <cfparam name="PageNum_vehicleSearch" default="1">
      <cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
      <cfquery name="vehicleSearch" datasource="saa">
      SELECT * FROM saa.vehicle_ad WHERE veh_year BETWEEN '#FORM.vehicle_yearup#' AND '#FORM.vehicle_yeardown#' AND vehicle_type = '#FORM.vehicle_type#' ORDER BY veh_year ASC
      </cfquery>
      <cfset MaxRows_vehicleSearch=7>
      <cfset StartRow_vehicleSearch=Min((PageNum_vehicleSearch-1)*MaxRows_vehicleSearch+1,Max(vehicleS earch.RecordCount,1))>
      <cfset EndRow_vehicleSearch=Min(StartRow_vehicleSearch+MaxRows_vehicleSearch-1,vehicleSearch.Rec ordCount)>
      <cfset TotalPages_vehicleSearch=Ceiling(vehicleSearch.RecordCount/MaxRows_vehicleSearch)><!DOCTY PE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " http://www.w3.org/TR/html4/loose.dtd">
      <html>
      <head>
      <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
      <title>buyerSearchresults</title>
      <style type="text/css">
      <!--
      .style1 {
      font-size: 18px;
      font-weight: bold;
      }
      .style3 {font-size: small}
      .style4 {
      font-size: 12px;
      font-weight: bold;
      }
      -->
      </style>
      </head>

      <body>
      <h2 align="left">Click on "Picture" or "Make" links to view vehicle details</h2>
      <table width="800" height="100" border="1" bordercolor="#0000FF" >
      <tr>
      <td align="center" valign="middle"><span class="style4">Picture</span></td>
      <td align="center" valign="middle"><span class="style4">Year</span></td>
      <td align="center" valign="middle"><span class="style4">Make</span></td>
      <td align="center" valign="middle"><span class="style4">Model</span></td>
      <td align="center" valign="middle"><span class="style4">Price</span></td>
      <td align="center" valign="middle"><span class="style4">Exterior Color</span></td>
      <td align="center" valign="middle"><span class="style4">Mileage</span></td>
      <td align="center" valign="middle"><span class="style4">Private Seller or Dealer</span></td>
      </tr>
      <cfoutput query="vehicleSearch">
      <tr>
      <td align="center" valign="middle"><a href="buyerDetailresults.cfm?recordID=#vehicleSearch.ad_id#" class="style4"><img src="#vehicleSearch.image1#" width="80" height="60"></td>
      <td align="center" valign="middle" class="style4">#vehicleSearch.veh_year# </td>
      <td align="center" valign="middle"><a href="buyerDetailresults.cfm?recordID=#vehicleSearch.ad_id#" class="style4">#vehicleSearch.make# </a></td>
      <td align="center" valign="middle" class="style4">#vehicleSearch.model# </td>
      <td align="center" valign="middle" class="style4">#DollarFormat(vehicleSearch.price)# </td>
      <td align="center" valign="middle" class="style4">#vehicleSearch.ext_color# </td>
      <td align="center" valign="middle" class="style4">#vehicleSearch.mileage# </td>
      <td align="center" valign="middle" class="style4"><img src="#vehicleSearch.dealer_logo#"> </td>
      </tr>
      </cfoutput>
      </table>
      <br>
      <table width="50%" border="0" align="center" >
      <cfoutput>
      <tr>
      <td width="23%" align="center"><cfif PageNum_vehicleSearch GT 1>
      <a href="#CurrentPage#?PageNum_vehicleSearch=1#QueryString_vehicleSearch#">First</a>
      </cfif>
      </td>
      <td width="31%" align="center"><cfif PageNum_vehicleSearch GT 1>
      <a href="#CurrentPage#?PageNum_vehicleSearch=#Max(DecrementValue(PageNum_vehicleSearch),1)## QueryString_vehicleSearch#">Previous</a>
      </cfif>
      </td>
      <td width="23%" align="center"><cfif PageNum_vehicleSearch LT TotalPages_vehicleSearch>
      <a href="#CurrentPage#?PageNum_vehicleSearch=#Min(IncrementValue(PageNum_vehicleSearch),Tota lPages_vehicleSearch)##QueryString_vehicleSearch#">Next</a>
      </cfif>
      </td>
      <td width="23%" align="center"><cfif PageNum_vehicleSearch LT TotalPages_vehicleSearch>
      <a href="#CurrentPage#?PageNum_vehicleSearch=#TotalPages_vehicleSearch##QueryString_vehicleS earch#">Last</a>
      </cfif>
      </td>
      </tr>
      </cfoutput>
      </table>
      <cfoutput>Records #StartRow_vehicleSearch# to #EndRow_vehicleSearch# of #vehicleSearch.RecordCount# </cfoutput>
      </body>
      </html>


      Thanks in advance for any help. Shane