Well, how many records are you going to have in the table for a particular
ID? If ID is the unique, primary key, the first time you run it, it selects
the record for ID=1, and gives you "prior" and "next" links for ID=0 and
ID=2. The maxrows issue is a smokescreen to your real problem. Check to
see what the value of ID is each time to make sure things are happening the
way you want them to. If there are gaps in in your ID values, you will also
have issues, as well as the fact that it is doubtful that you would have an
ID of 0.
DC
----- Original Message -----
From: "Mike" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 14:46
Subject: Re: Code review PLEASE
> Your the second one to say that, but locally everything works fine, if I
> turn the max rows off then I will see all the records and I only want to
see
> one record at time
>
>
> Michael
>
>
>
> "Cami Lawson" <[EMAIL PROTECTED]> wrote in message
> 010001c0ad87$6836dcb0$[EMAIL PROTECTED]">news:010001c0ad87$6836dcb0$[EMAIL PROTECTED]...
> > You have a maxrows = 1 on the query.
> >
> > $.02
> > ----- Original Message -----
> > From: "Mike" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, March 15, 2001 12:59 PM
> > Subject: Code review PLEASE
> >
> >
> > > This is really making me go bald, I have a page that has next and
> > previous,
> > > and when viewed locally I can see everything, when I ftp to my host
(and
> > yes
> > > the odbc is working and correct) I can only see the first record, and
> > > nothing after that.
> > >
> > > I have tried putting the database(access) in the database folder, and
> > > straight in the directory with all the pages and I still get the same
> > > result, I have replaced the database, and contacted my host, and they
> say
> > > that the code is fine from what little the guy knew about CF.
> > >
> > > Below is the code if someone could share there knowledge I would as
> always
> > > appreciate it.
> > >
> > > And thank you
> > >
> > >
> > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
> > >
> > > <HTML>
> > > <HEAD>
> > > <CFPARAM Name="ID" Default=1>
> > >
> > > <cfquery name="selectcandidate" datasource="interview" maxrows=1
> > > dbtype="ODBC">
> > > SELECT ID, EmpCandidate, SKillBackground, Status, Recruiter,
> Profile
> > > FROM interview
> > > WHERE ID=#ID#
> > > </cfquery>
> > >
> > > <CFSET NextID=#id#+1>
> > > <CFSET PrevID=#id#-1>
> > >
> > > <TITLE>Interview Candidates</TITLE>
> > > </HEAD>
> > >
> > > <BODY bgcolor="6699ff">
> > > <!--- include toolbar.cfm--->
> > > <cfinclude template="Toolbar.cfm">
> > >
> > > <cfoutput query="Selectcandidate">
> > > <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>
> > > <table width="85%" border="0">
> > > <TR>
> > > <TD align="left"><a href="default2.cfm?ID=#PrevID#">Previous</a></TD>
> > > <td align="right"><a href="default2.cfm?ID=#NextID#">Next</a></td>
> > > </td></TR></table>
> > > </cfoutput>
> > >
> > >
> > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
