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>

"Keith C. Ivey" <[EMAIL PROTECTED]> wrote in message
3ABB6398.2825.165E1F@localhost">news:3ABB6398.2825.165E1F@localhost...
> On 23 Mar 2001, at 13:49, Michael wrote:
>
> > No its name is default2.cfm,  it will show me the first record
> > but after that I get a 404 error.
>
> But this is what you had in the code you posted:
>
> > <a href="cfoutput-default2.cfm?First=#StartNextPage#">Next
> > Record</a>
>
> If it's called default2.cfm, why are you linking to it as
> cfoutput-default2.cfm?
>
> Keith C. Ivey <[EMAIL PROTECTED]>
> Webmaster, EEI Communications
> 66 Canal Center Plaza, Suite 200
> Alexandria, VA  22314
> Telephone:  703-683-0683
> Fax:  703-683-4915
> Web Site:  http://www.eeicommunications.com
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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

Reply via email to