No I already corrected that now the page is showing page 1, but when I go to
page 2 it does not display the data
"Hayes, David" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> href="cfoutput-default2.cfm..." looks odd; is cfoutput really part of your
> file name?
>
> -----Original Message-----
> From: Michael [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 23, 2001 11:43 AM
> To: CF-Talk
> Subject: Why wont this advance to the next record
>
>
> Appreciate it someone could tell me why this wont advance to the next
> record, keep getting 404 error object not found
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
>
> <cfparam name="firstrow" default="1">
> <CFIF IsDefined("URL.first")>
> <cfset firstrow = url.first>
> </CFIF>
> <Cfset startnextpage = Firstrow + 1>
>
> <CFPARAM Name="ID" Default=1>
> <HTML>
> <HEAD>
>
>
> <cfquery name="selectcandidate" datasource="interview" dbtype="ODBC">
> SELECT ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile
> FROM interview
> WHERE ID=#ID#
> </cfquery>
>
> <TITLE>Interview Candidates</TITLE>
> </HEAD>
>
> <BODY bgcolor="6699ff">
> <!--- include toolbar.cfm--->
> <cfinclude template="Toolbar.cfm">
>
> <cfoutput query="Selectcandidate" startrow="#firstrow#" maxrows="1">
> <table cellpadding="10">
> <tr>
> <td>ID</td><br>
> <td>#id#</td><br>
> </tr>
> <tr>
> <td>Candidate Name</td><br>
> <td>#EmpCandidate#</td><br>
> </tr>
> <tr>
> <td>Skill Background</td>
> <td>#SKillBackground#</td>
> </tr>
> <tr>
> <td>Status</td>
> <td>#Status#</td>
> </tr>
> <tr>
> <td>Recruiter</td>
> <td>#Recruiter#</td>
> </tr>
> </table>
> <BR><BR>
> <a href="cfoutput-default2.cfm?First=#StartNextPage#">Next Record</a>
> </cfoutput>
> </body>
>
> Thank You
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
