Yes
"Stephenie Hamilton" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> this may seem pretty obvious, but is your host using the same version of
CF
> as you are locally?
>
> --
> Stephenie Hamilton
> Senior ColdFusion Administrator
> Express Technologies, Inc.
> want CF_Freedom?
> try CFXHosting.com
>
>
>
>
> -----Original Message-----
> From: Mike [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 2:47 PM
> To: CF-Talk
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
