here is the whole file ... not sure exactly what you want ... still learning
here =)
.. i need to sit down and go through it to see why it now works
<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfparam name="PageNum_searchResults" default="1">
<cfquery name="searchResults" datasource="perd">
SELECT * FROM RecordTable ORDER BY Title ASC
</cfquery>
<cfset MaxRows_searchResults=10>
<cfset
StartRow_searchResults=Min((PageNum_searchResults-1)*MaxRows_searchResults+1
,Max(searchResults.RecordCount,1))>
<cfset
EndRow_searchResults=Min(StartRow_searchResults+MaxRows_searchResults-1,sear
chResults.RecordCount)>
<cfset
TotalPages_searchResults=Ceiling(searchResults.RecordCount/MaxRows_searchRes
ults)>
<cfset QueryString_searchResults=Iif(CGI.QUERY_STRING NEQ
"",DE("&"&CGI.QUERY_STRING),DE(""))>
<cfset
tempPos=ListContainsNoCase(QueryString_searchResults,"PageNum_searchResults=
","&")>
<cfif tempPos NEQ 0>
<cfset
QueryString_searchResults=ListDeleteAt(QueryString_searchResults,tempPos,"&"
)>
</cfif>
<html>
<head>
<title>Material Results</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><font color="#00CACA" size="7" face="Times New Roman, Times,
serif"><strong><em>Material</em></strong></font>
<font size="5">RESULTS</font> </td>
</tr>
<tr>
<td>
<hr></td>
</tr>
</table>
</p>
<cfoutput>
<table border="0" width="100%" align="center">
<tr>
<td width="20%" align="center"><div align="left">Records
#StartRow_searchResults#
to #EndRow_searchResults# of #searchResults.RecordCount#
</div></td>
<td width="18%" align="center"> <div align="left">
<cfif PageNum_searchResults LT TotalPages_searchResults>
<a
href="#CurrentPage#?PageNum_searchResults=#Min(IncrementValue(PageNum_search
Results),TotalPages_searchResults)##QueryString_searchResults#"><Next>
</a>
</cfif>
</div></td>
<td width="62%" align="center"> <div align="left">
<cfif PageNum_searchResults GT 1>
<a
href="#CurrentPage#?PageNum_searchResults=#Max(DecrementValue(PageNum_search
Results),1)##QueryString_searchResults#"><Previous></a>
</cfif>
</div></td>
</tr>
</table>
<br>
</cfoutput>
<table width="100%" border="1" align="center">
<tr bgcolor="#CCCCCC">
<td width="53%"><strong>Title</strong></td>
<td width="28%"><strong>Author</strong></td>
<td width="19%"><strong>Date</strong></td>
</tr>
<cfoutput query="searchResults" startRow="#StartRow_searchResults#"
maxRows="#MaxRows_searchResults#">
<tr>
<td><a
href="matdetails.cfm?recordID=#searchResults.RecordId#">#searchResults.Title
# </a></td>
<td>#searchResults.Author# </td>
<td>#dateformat(searchResults.Date, "yyyy/mm/dd")# </td>
</tr>
</cfoutput>
</table>
<br><cfoutput>
<table border="0" width="100%" align="left">
<tr>
<td width="20%" align="center"><div align="left">Records
#StartRow_searchResults#
to #EndRow_searchResults# of #searchResults.RecordCount#
</div></td>
<td width="18%" align="center"> <div align="left">
<cfif PageNum_searchResults LT TotalPages_searchResults>
<a
href="#CurrentPage#?PageNum_searchResults=#Min(IncrementValue(PageNum_search
Results),TotalPages_searchResults)##QueryString_searchResults#"><Next>
</a>
</cfif>
</div></td>
<td width="62%" align="center"> <div align="left">
<cfif PageNum_searchResults GT 1>
<a
href="#CurrentPage#?PageNum_searchResults=#Max(DecrementValue(PageNum_search
Results),1)##QueryString_searchResults#"><Previous></a>
</cfif>
</div></td>
</tr>
</table>
<br>
</cfoutput>
<br>
<cfoutput> </cfoutput>
</body>
</html>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
