Try Something like this, not exact w/ your code but maybe it will help:
<cfquery datasource="#datasource#" name="QRYNAME">
<!-- your statement -->
</cfquery>
<cfset ProdCount = QRYNAME.RecordCount>
<cfset Count = 1>
<CFPARAM NAME="URL.StartRow" DEFAULT="1">
<cfoutput query="QRYNAME" startrow=#URL.StartRow# maxrows=1>
<cfif Count LTE "1" AND Count EQ "1">
<cfif Count EQ "0">
<table>
</cfif>
<!-- the code for your <tr>'s and <td>'s -->
</cfif>
<cfif Count EQ "1">
</table>
</cfif>
<cfset Count = Count + 1>
</cfoutput>
<table>
<tr>
<td><CFOUTPUT><cfif url.startRow NEQ 1><a
href="javascript:history.go(-1)"><b> <-- Back</b></a></cfif><cfif
url.startRow + 0 LT QRYNAME.recordCount><A
HREF="cfoutput-default2.cfm?StartRow=#Evaluate(URL.StartRow +
1)#"><b>Next --> </b></a></cfif></CFOUTPUT></td>
</tr>
</table>
HTH
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
----- Original Message -----
From: "Michael" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 23, 2001 10:42 AM
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
