change mawrows = 1 to something else, like user definable.
Alexander Sicular
Technical Director, Information Technology
The Neurological Institute of New York
Columbia University
212.305.1318
[EMAIL PROTECTED]
> -----Original Message-----
> From: Mike [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 2:00 PM
> To: CF-Talk
> 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
