Question 1, how many records are in your database?
Question 2, You're specifying "Where ID = 1", this might be causing only ONE
recordset to be returned from the database. Try just running the query on a
separate page and see how many recordsets you get.
Just a thought,
Hatton
-----Original Message-----
From: Michael [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 3:56 PM
To: CF-Talk
Subject: Re: Why wont this advance to the next record
This is the latest and greatest and it still does not work properly shows
the first record and then goes to a blank screen.
<!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>
<tr>
<td valign="top">Profile</td>
<td><textarea cols="50" rows="5" name="Profile">#profile#</textarea></td>
</tr>
</table>
<BR><BR></cfoutput>
<cfoutput>
<a href="default2.cfm?First=#StartNextPage#">Next Record</a>
</cfoutput>
</html>
</body>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
