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(vehicleSearch.RecordCount,1))>
<cfset
EndRow_vehicleSearch=Min(StartRow_vehicleSearch+MaxRows_vehicleSearch-1,vehicleSearch.RecordCount)>
<cfset
TotalPages_vehicleSearch=Ceiling(vehicleSearch.RecordCount/MaxRows_vehicleSearch)><!DOCTYPE
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),TotalPages_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_vehicleSearch#">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
1 Correct answer
1
Reply
AdChoices