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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
