Here you go:
<cfif go neq "no">
<cfoutput>
<b>#get_companies.recordcount#</b> record<cfif (get_companies.recordcount
gt 1) or (get_companies.recordcount eq 0)>s</cfif> matched your search
criteria.<br>
<br>
<a href="#script_name#?fuseaction=companies_search_form">Click here</a> to
return to the Medical Device Companies Search Form.
<br>
<br>
</cfoutput>
<cfif get_companies.recordcount gt 0>
<cfset PrevStart = Start - MaxRows>
<cfif PrevStart lt 0>
<cfset PrevStart = get_companies.recordcount - MaxRows + 1>
</cfif>
<cfset NextStart = Start + MaxRows>
<cfif NextStart gt get_companies.RecordCount>
<cfset NextStart = 1>
</cfif>
<cfoutput>
<table
width="#session.table_width#"
border="#session.table_border#"
cellspacing="#session.table_cellspacing#"
cellpadding="#session.table_cellpadding#"
align="#session.table_align#"
bordercolor="#session.table_bordercolor#"
bordercolorlight="#session.table_bordercolorlight#"
bordercolordark="#session.table_bordercolordark#"
bgcolor="#session.table_bgcolor#">
<tr>
<td colspan="3"><font face="#session.fontface#" size="#session.fontsize#"><a
href="#script_name#?fuseaction=#fuseaction#&start=1&ename=#URLEncodedFormat(
ename)#&county=#URLEncodedFormat(county)#&state=#URLEncodedFormat(state)#&so
rtby=ename&search_option=#URLEncodedFormat(search_option)#">Original Device
Companies Search Results</a> </td>
<td colspan="5" align="right"><font face="#session.fontface#"
size="#session.fontsize#">
<cfif get_companies.recordcount gt 10>
<a
href="#script_name#?fuseaction=#fuseaction#&start=#PrevStart#&ename=#URLEnco
dedFormat(ename)#&county=#URLEncodedFormat(county)#&state=#URLEncodedFormat(
state)#&sortby=#sortby#&search_option=#URLEncodedFormat(search_option)#">Pre
vious #maxrows#</a> <a
href="#script_name#?fuseaction=#fuseaction#&start=#NextStart#&ename=#URLEnco
dedFormat(ename)#&county=#URLEncodedFormat(county)#&state=#URLEncodedFormat(
state)#&sortby=#sortby#&search_option=#URLEncodedFormat(search_option)#">Nex
t #maxrows#</a>
</cfif>
</td>
</tr>
<tr>
<td bgcolor="#session.headerrowcolor#"><font face="#session.fontface#"
size="#session.tablefontsize#"> </td>
<td bgcolor="#session.headerrowcolor#"><font face="#session.fontface#"
size="#session.tablefontsize#"><b><a
href="#script_name#?fuseaction=#fuseaction#&start=#start#&ename=#URLEncodedF
ormat(ename)#&county=#URLEncodedFormat(county)#&state=#URLEncodedFormat(stat
e)#&sortby=ename&search_option=#URLEncodedFormat(search_option)#">Company
Name / Address / Phone</a></b> </td>
<td bgcolor="#session.headerrowcolor#"><font face="#session.fontface#"
size="#session.tablefontsize#"><b><a
href="#script_name#?fuseaction=#fuseaction#&start=#start#&ename=#URLEncodedF
ormat(ename)#&county=#URLEncodedFormat(county)#&state=#URLEncodedFormat(stat
e)#&sortby=ecity&search_option=#URLEncodedFormat(search_option)#">City</a></
b> </td>
<td bgcolor="#session.headerrowcolor#"><font face="#session.fontface#"
size="#session.tablefontsize#"><b><a
href="#script_name#?fuseaction=#fuseaction#&start=#Start#&ename=#URLEncodedF
ormat(ename)#&county=#URLEncodedFormat(county)#&state=#URLEncodedFormat(stat
e)#&sortby=estate&search_option=#URLEncodedFormat(search_option)#">State</a>
</b> </td>
<td bgcolor="#session.headerrowcolor#"><font face="#session.fontface#"
size="#session.tablefontsize#"><b><a
href="#script_name#?fuseaction=#fuseaction#&start=#Start#&ename=#URLEncodedF
ormat(ename)#&county=#URLEncodedFormat(county)#&state=#URLEncodedFormat(stat
e)#&sortby=ezip&search_option=#URLEncodedFormat(search_option)#">Zip</a></b>
</td>
<td bgcolor="#session.headerrowcolor#"><font face="#session.fontface#"
size="#session.tablefontsize#"><b><a
href="#script_name#?fuseaction=#fuseaction#&start=#Start#&ename=#URLEncodedF
ormat(ename)#&county=#URLEncodedFormat(county)#&state=#URLEncodedFormat(stat
e)#&sortby=ecounty&search_option=#URLEncodedFormat(search_option)#">County</
a></b> </td>
<td bgcolor="#session.headerrowcolor#"><font face="#session.fontface#"
size="#session.tablefontsize#"><b><a
href="#script_name#?fuseaction=#fuseaction#&start=#Start#&ename=#URLEncodedF
ormat(ename)#&county=#URLEncodedFormat(county)#&state=#URLEncodedFormat(stat
e)#&sortby=ecountry&search_option=#URLEncodedFormat(search_option)#">Country
</a></b> </td>
<cfif session.groups contains "1">
<td bgcolor="#session.headerrowcolor#"><font face="#session.fontface#"
size="#session.tablefontsize#"><b>Edit</b> </td>
</cfif>
</tr>
</cfoutput>
<cfoutput query="get_companies" startrow="#start#" maxrows="#maxrows#">
<cfif currentrow mod 2 eq 1>
<cfset currentrowbgcolor = session.rowcolor1>
<cfelse>
<cfset currentrowbgcolor = session.rowcolor2>
</cfif>
<tr>
<td bgcolor="#currentrowbgcolor#" valign="top"><font
face="#session.fontface#"
size="#session.tablefontsize#">#currentrow# </td>
<td bgcolor="#currentrowbgcolor#" align="top"><font
face="#session.fontface#" size="#session.tablefontsize#">
<a
href="#session.web_root_path#/companies/index.cfm?fuseaction=companies_detai
l&eregnum=#eregnum#&reset_search=1">#ename#</a><br>
#estreet1#
<cfif Trim(estreet2) neq ""><br>
#estreet2#<br>
</cfif>
<cfif Trim(ophone) neq ""><br>
#ophone#
</cfif>
</td>
<td bgcolor="#currentrowbgcolor#" valign="top"><font
face="#session.fontface#" size="#session.tablefontsize#">#ecity# </td>
<td bgcolor="#currentrowbgcolor#" valign="top"><font
face="#session.fontface#" size="#session.tablefontsize#">#estate# </td>
<td bgcolor="#currentrowbgcolor#" valign="top"><font
face="#session.fontface#" size="#session.tablefontsize#">#ezip#<cfif
Trim(ezipext) neq "">-#ezipext#</cfif> </td>
<td bgcolor="#currentrowbgcolor#" valign="top"><font
face="#session.fontface#"
size="#session.tablefontsize#">#ecounty# </td>
<td bgcolor="#currentrowbgcolor#" valign="top"><font
face="#session.fontface#"
size="#session.tablefontsize#">#ecountry# </td>
<cfif session.groups contains "1">
<td bgcolor="#currentrowbgcolor#" valign="top"><font
face="#session.fontface#" size="#session.tablefontsize#"><a
href="#session.web_root_path#/admin/companies/index.cfm?fuseaction=admin_com
panies_edit&id_registration=#id_registration#">Edit</a></td>
</cfif>
</tr>
</cfoutput>
<cfoutput>
<tr>
<td colspan="3"><font face="#session.fontface#" size="#session.fontsize#"><a
href="#script_name#?fuseaction=#fuseaction#&start=1&ename=#URLEncodedFormat(
ename)#&county=#URLEncodedFormat(county)#&state=#URLEncodedFormat(state)#&so
rtby=ename&search_option=#URLEncodedFormat(search_option)#">Original Device
Companies Search Results</a> </td>
<td colspan="5" align="right"><font face="#session.fontface#"
size="#session.fontsize#">
<cfif get_companies.recordcount gt 10>
<a
href="#script_name#?fuseaction=#fuseaction#&start=#PrevStart#&ename=#URLEnco
dedFormat(ename)#&county=#URLEncodedFormat(county)#&state=#URLEncodedFormat(
state)#&sortby=#sortby#&search_option=#URLEncodedFormat(search_option)#">Pre
vious #maxrows#</a> <a
href="#script_name#?fuseaction=#fuseaction#&start=#NextStart#&ename=#URLEnco
dedFormat(ename)#&county=#URLEncodedFormat(county)#&state=#URLEncodedFormat(
state)#&sortby=#sortby#&search_option=#URLEncodedFormat(search_option)#">Nex
t #maxrows#</a>
</cfif>
</td>
</tr>
</cfoutput>
</table>
</cfif>
</cfif>
=========================================
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
=========================================
> -----Original Message-----
> From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 31, 2001 11:09 AM
> To: CF-Talk
> Subject: Next/Previous
>
>
> Anyone have code for a good previous and next record display. I can write
> one but I am feeling lazy.
>
> TIA,
> Joshua Tipton
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
