RE: Why wont this advance to the next record
Let me add one more: 4) If your template contains a hyperlink to itself, or a form which submits to itself, don't hard-wire the template name in the link or form. Use CGI.SCRIPT_NAME, so everyone understands the flow. This thread illustrates the needless confusion that can be caused. -David On Friday, March 23, 2001 3:09 PM, Hayes, David [SMTP:[EMAIL PROTECTED]] wrote: > A few thoughts: > > 1) Cache the query so you're not calling the db every time the page loads, > > 2) Turn on debugging and look at the SQL statement that's actually being > generated, > > 3) remove ; I believe you're grabbing the same > one record from the db every time. There is no second row in your query > object. > > > > -Original Message- > From: Michael [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 23, 2001 2:56 PM > To: CF-Talk > Subject: Re: Why wont this advance to the next record > > > This is the latest and greatest and it still does not work properly shows > the first record and then goes to a blank screen. > > > > > > > > > > > > > > > > > SELECT ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile > FROMinterview > WHERE ID=#ID# > > > Interview Candidates > > > > > > > > > > ID > #id# > > > Candidate Name > #EmpCandidate# > > > Skill Background > #SKillBackground# > > > Status > #Status# > > > Recruiter > #Recruiter# > > > Profile > #profile# > > > > > Next Record > > > > > "Keith C. Ivey" <[EMAIL PROTECTED]> wrote in message > 3ABB6398.2825.165E1F@localhost">news:3ABB6398.2825.165E1F@localhost... > > On 23 Mar 2001, at 13:49, Michael wrote: > > > > > No its name is default2.cfm, it will show me the first record > > > but after that I get a 404 error. > > > > But this is what you had in the code you posted: > > > > > Next > > > Record > > > > If it's called default2.cfm, why are you linking to it as > > cfoutput-default2.cfm? ~~ 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
RE: Why wont this advance to the next record
Question 1, how many records are in your database? Question 2, You're specifying "Where ID = 1", this might be causing only ONE recordset to be returned from the database. Try just running the query on a separate page and see how many recordsets you get. Just a thought, Hatton -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 3:56 PM To: CF-Talk Subject: Re: Why wont this advance to the next record This is the latest and greatest and it still does not work properly shows the first record and then goes to a blank screen. SELECT ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile FROMinterview WHERE ID=#ID# Interview Candidates ID #id# Candidate Name #EmpCandidate# Skill Background #SKillBackground# Status #Status# Recruiter #Recruiter# Profile #profile# Next Record ~~ 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
RE: Why wont this advance to the next record
A few thoughts: 1) Cache the query so you're not calling the db every time the page loads, 2) Turn on debugging and look at the SQL statement that's actually being generated, 3) remove ; I believe you're grabbing the same one record from the db every time. There is no second row in your query object. -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 2:56 PM To: CF-Talk Subject: Re: Why wont this advance to the next record This is the latest and greatest and it still does not work properly shows the first record and then goes to a blank screen. SELECT ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile FROMinterview WHERE ID=#ID# Interview Candidates ID #id# Candidate Name #EmpCandidate# Skill Background #SKillBackground# Status #Status# Recruiter #Recruiter# Profile #profile# Next Record "Keith C. Ivey" <[EMAIL PROTECTED]> wrote in message 3ABB6398.2825.165E1F@localhost">news:3ABB6398.2825.165E1F@localhost... > On 23 Mar 2001, at 13:49, Michael wrote: > > > No its name is default2.cfm, it will show me the first record > > but after that I get a 404 error. > > But this is what you had in the code you posted: > > > Next > > Record > > If it's called default2.cfm, why are you linking to it as > cfoutput-default2.cfm? > > Keith C. Ivey <[EMAIL PROTECTED]> > Webmaster, EEI Communications > 66 Canal Center Plaza, Suite 200 > Alexandria, VA 22314 > Telephone: 703-683-0683 > Fax: 703-683-4915 > Web Site: http://www.eeicommunications.com > > ~~ 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
Re: Why wont this advance to the next record
This is the latest and greatest and it still does not work properly shows the first record and then goes to a blank screen. SELECT ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile FROMinterview WHERE ID=#ID# Interview Candidates ID #id# Candidate Name #EmpCandidate# Skill Background #SKillBackground# Status #Status# Recruiter #Recruiter# Profile #profile# Next Record "Keith C. Ivey" <[EMAIL PROTECTED]> wrote in message 3ABB6398.2825.165E1F@localhost">news:3ABB6398.2825.165E1F@localhost... > On 23 Mar 2001, at 13:49, Michael wrote: > > > No its name is default2.cfm, it will show me the first record > > but after that I get a 404 error. > > But this is what you had in the code you posted: > > > Next > > Record > > If it's called default2.cfm, why are you linking to it as > cfoutput-default2.cfm? > > Keith C. Ivey <[EMAIL PROTECTED]> > Webmaster, EEI Communications > 66 Canal Center Plaza, Suite 200 > Alexandria, VA 22314 > Telephone: 703-683-0683 > Fax: 703-683-4915 > Web Site: http://www.eeicommunications.com > > ~~ 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
Re: Why wont this advance to the next record
No I already corrected that now the page is showing page 1, but when I go to page 2 it does not display the data "Hayes, David" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > href="cfoutput-default2.cfm..." looks odd; is cfoutput really part of your > file name? > > -Original Message- > From: Michael [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 23, 2001 11:43 AM > To: CF-Talk > Subject: Why wont this advance to the next record > > > Appreciate it someone could tell me why this wont advance to the next > record, keep getting 404 error object not found > > > > > > > > > > > > > > > > SELECT ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile > FROMinterview > WHERE ID=#ID# > > > Interview Candidates > > > > > > > > > > ID > #id# > > > Candidate Name > #EmpCandidate# > > > Skill Background > #SKillBackground# > > > Status > #Status# > > > Recruiter > #Recruiter# > > > > Next Record > > > > Thank You > ~~ 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
Re: Why wont this advance to the next record
On 23 Mar 2001, at 13:49, Michael wrote: > No its name is default2.cfm, it will show me the first record > but after that I get a 404 error. But this is what you had in the code you posted: > Next > Record If it's called default2.cfm, why are you linking to it as cfoutput-default2.cfm? Keith C. Ivey <[EMAIL PROTECTED]> Webmaster, EEI Communications 66 Canal Center Plaza, Suite 200 Alexandria, VA 22314 Telephone: 703-683-0683 Fax: 703-683-4915 Web Site: http://www.eeicommunications.com ~~ 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
RE: Why wont this advance to the next record
href="cfoutput-default2.cfm..." looks odd; is cfoutput really part of your file name? -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 11:43 AM To: CF-Talk Subject: Why wont this advance to the next record Appreciate it someone could tell me why this wont advance to the next record, keep getting 404 error object not found SELECT ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile FROMinterview WHERE ID=#ID# Interview Candidates ID #id# Candidate Name #EmpCandidate# Skill Background #SKillBackground# Status #Status# Recruiter #Recruiter# Next Record Thank You ~~ 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
Re: Why wont this advance to the next record
No I got it to go to the next page now its not displaying the data, is this Friday or Monday? "Bryan Love" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > A 404 error indicates that the CF server cannot find a file you are trying > to CFINCLUDE. > In this case it must be this line: > > since that is the only include you are using. If you are on a UNIX machine > be sure that the case sensitivity of the filename is correct. > > I've also made some minor code changes that make your logic slightly cleaner > - (just suggestions) > > Bryan Love ACP > Internet Application Developer > [EMAIL PROTECTED] > > > > -Original Message- > From: Michael [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 23, 2001 9:43 AM > To: CF-Talk > Subject: Why wont this advance to the next record > > > Appreciate it someone could tell me why this wont advance to the next > record, keep getting 404 error object not found > > > > > > > > > > > > > SELECT ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile > FROMinterview > WHERE ID=#ID# > > > Interview Candidates > > > > > > > > > > ID > #id# > > > Candidate Name > #EmpCandidate# > > > Skill Background > #SKillBackground# > > > Status > #Status# > > > Recruiter > #Recruiter# > > > > Next Record > > > > Thank You > ~~ 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
Re: Why wont this advance to the next record
No its name is default2.cfm, it will show me the first record but after that I get a 404 error. "Ian Tait" <[EMAIL PROTECTED]> wrote in message F7797736377BD311A0B0009027B0A9661FE9C1@THOUGHTBUBBLE01">news:F7797736377BD311A0B0009027B0A9661FE9C1@THOUGHTBUBBLE01... > Is the code below called cfoutput-default2.cfm? > > Ian > > > -Original Message- > > From: Michael [mailto:[EMAIL PROTECTED]] > > Sent: 23 March 2001 17:43 > > To: CF-Talk > > Subject: Why wont this advance to the next record > > > > > > Appreciate it someone could tell me why this wont advance to the next > > record, keep getting 404 error object not found > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > SELECT ID, EmpCandidate, SKillBackground, Status, > > Recruiter, Profile > > FROMinterview > > WHERE ID=#ID# > > > > > > Interview Candidates > > > > > > > > > > > > > > > > > > > > ID > > #id# > > > > > > Candidate Name > > #EmpCandidate# > > > > > > Skill Background > > #SKillBackground# > > > > > > Status > > #Status# > > > > > > Recruiter > > #Recruiter# > > > > > > > > Next Record > > > > > > > > Thank You > > > > > > > > > > > ~~ 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
Re: Why wont this advance to the next record
Try Something like this, not exact w/ your code but maybe it will help: <-- BackNext --> HTH Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.com - Original Message - From: "Michael" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, March 23, 2001 10:42 AM Subject: Why wont this advance to the next record > Appreciate it someone could tell me why this wont advance to the next > record, keep getting 404 error object not found > > > > > > > > > > > > > > > > SELECT ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile > FROMinterview > WHERE ID=#ID# > > > Interview Candidates > > > > > > > > > > ID > #id# > > > Candidate Name > #EmpCandidate# > > > Skill Background > #SKillBackground# > > > Status > #Status# > > > Recruiter > #Recruiter# > > > > Next Record > > > > Thank You > > > > ~~ 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
RE: Why wont this advance to the next record
A 404 error indicates that the CF server cannot find a file you are trying to CFINCLUDE. In this case it must be this line: since that is the only include you are using. If you are on a UNIX machine be sure that the case sensitivity of the filename is correct. I've also made some minor code changes that make your logic slightly cleaner - (just suggestions) Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 9:43 AM To: CF-Talk Subject: Why wont this advance to the next record Appreciate it someone could tell me why this wont advance to the next record, keep getting 404 error object not found SELECT ID, EmpCandidate, SKillBackground, Status, Recruiter, Profile FROMinterview WHERE ID=#ID# Interview Candidates ID #id# Candidate Name #EmpCandidate# Skill Background #SKillBackground# Status #Status# Recruiter #Recruiter# Next Record Thank You ~~ 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
RE: Why wont this advance to the next record
Is the code below called cfoutput-default2.cfm? Ian > -Original Message- > From: Michael [mailto:[EMAIL PROTECTED]] > Sent: 23 March 2001 17:43 > To: CF-Talk > Subject: Why wont this advance to the next record > > > Appreciate it someone could tell me why this wont advance to the next > record, keep getting 404 error object not found > > > > > > > > > > > > > > > > SELECT ID, EmpCandidate, SKillBackground, Status, > Recruiter, Profile > FROMinterview > WHERE ID=#ID# > > > Interview Candidates > > > > > > > > > > ID > #id# > > > Candidate Name > #EmpCandidate# > > > Skill Background > #SKillBackground# > > > Status > #Status# > > > Recruiter > #Recruiter# > > > > Next Record > > > > Thank You > > > > > ~~ 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
