Are you trying to have the user page through one record at a time? Cause
that's what you're going to get with this. You'll only ever get one user
whose id equals the passed id
---snip---> WHERE ID=#ID#
What I think you want is something like the following (quickly cut from
existing code, so probably needs cleanup).
<cfset maxrows = "5">
<cfparam name="start" default = "1">
<cfquery name="selectcandidate" datasource="interview">
SELECT ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile
FROM interview
</cfquery>
<cfoutput query="selectcandidate" startrow="#start#" maxrows="#maxrows#">
Table o' info here
<!--------------------------------------------------------------------------
-----------
Add previous and next buttons if needed.
----------------------------------------------------------------------------
------------>
<cfset prevstart = start - maxrows>
<cfset nextstart = start + maxrows>
<table width="100%" cellpadding="5">
<tr>
<td>
<cfif prevstart GTE 1>
<cfoutput>
<form action="default2.cfm" method="post">
<input type="hidden" name="start" value="#prevstart#">
<input type="submit" value="Previous #maxrows#">
</form>
</cfoutput><cfelse> </cfif></td>
<td>
<cfif nextstart LT selectcandidates.recordcount>
<cfoutput><form action="default2.cfm" method="post">
<input type="hidden" name="start" value="#nextstart#">
<input type="submit" value="Next #maxrows#">
</form></cfoutput>
<cfelse>
</cfif>
</td>
</tr>
</table>
************************************************************
Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
