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
