Re: Loop Errors
Also on Line 77, the CFOUTPUT should *not* contain the GROUP attribute because it's being used to populate a select, not display output by group. Oops! My statement above is incorrect. In this case, the GROUP attribute in the CFOUTPUT behaves like SQL's DISTINCT function. It's not only OK to use, it's necessary to return the correct results. My apologies for any confusion this may have caused. ~Dina ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Loop Errors
You got the code to post? Robert Bailey [EMAIL PROTECTED] Famous for nothing! http://www.tinetics.com -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 7:50 AM To: CF-Talk Subject: Loop Errors Does anybody have any ideas on why I am getting a loop error from my code below I cant see why this is happening, any suggestions would be most helpful thanks... Error Occurred While Processing Request Error Diagnostic Information Loop error The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (23:1) to (23:42). Date/Time: Mon Jan 06 15:49:37 2003 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address: 121.100.25.2 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body !--- Select the ATA_Chapter, ATA_Section and title_Codes. --- cfquery name=rsquery1 datasource=intranetv8 SELECT a.category, a.catno, a.parent_level, b.category, b.catno, b.parent_level FROM category_menu a, category_menu b WHERE a.parent_level = b.catno ORDER BY a.category, b.category /cfquery !--- Select all the sub codes. --- script language = JavaScript !-- // For each chapter, create an array to hold the sections. // Each chapter array will be identified by the ATA_Chapter cfoutput query=rsATA1 group=category // Create the array ChapterArray#category# = new Array(); ChapterArrayVal#category# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 ChapterArray#category#[#i#] = #category#; ChapterArrayVal#category#[#i#] = #catno# #category#; /cfoutput /cfoutput // Function to populate the ATA_Sub_Codes for the ATA_Code selected function PopulateATASubCode() { // Only process the function if the first item is not selected. var indx = document.InsertForm.ATACode.selectedIndex; if (indx != 0) { // Find the Chapter var ThisChapter = document.InsertForm.ATACode[indx].value; // Set the length of the ATA_Sub_Codes drop down equal to the length of the Chapter's array var len; len = eval(ChapterArray + ThisChapter + .length); document.InsertForm.ATA_SubCode.length = len; // Put 'Select' as the first option in the SubCode drop-down document.InsertForm.ATA_SubCode[0].value = ; document.InsertForm.ATA_SubCode[0].text = Select ATA Sub Code; document.InsertForm.ATA_SubCode[0].selected = true; // Loop through the chapter's array and populate the SubCode drop down. for (i=1; ilen; i++) { document.InsertForm.ATA_SubCode.value = eval(ChapterArray + ThisChapter + ); document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal + ThisChapter + ); } } } //-- /script html head titleRequirements Database Add Requirement/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body form action=cfoutput#CurrentPage#/cfoutput method=POST name=InsertForm id=InsertForm table tr td select name=ATACode onChange=PopulateATASubCode(); option value=0Select ATA Code cfoutput query=rsATA1 group=category option value=#ATA_Chapter##category# /cfoutput /select select name=ATA_SubCode size=1 option value=0Select ATA Sub Code /select/td /tr /table /body /html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Loop Errors
:-) Can you get the result set back using cfdump also, can you just dump the data out as a test without all of the Javascript? -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 06 January 2003 15:50 To: CF-Talk Subject: Loop Errors Does anybody have any ideas on why I am getting a loop error from my code below I cant see why this is happening, any suggestions would be most helpful thanks... Error Occurred While Processing Request Error Diagnostic Information Loop error The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (23:1) to (23:42). Date/Time: Mon Jan 06 15:49:37 2003 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address: 121.100.25.2 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body !--- Select the ATA_Chapter, ATA_Section and title_Codes. --- cfquery name=rsquery1 datasource=intranetv8 SELECT a.category, a.catno, a.parent_level, b.category, b.catno, b.parent_level FROM category_menu a, category_menu b WHERE a.parent_level = b.catno ORDER BY a.category, b.category /cfquery !--- Select all the sub codes. --- script language = JavaScript !-- // For each chapter, create an array to hold the sections. // Each chapter array will be identified by the ATA_Chapter cfoutput query=rsATA1 group=category // Create the array ChapterArray#category# = new Array(); ChapterArrayVal#category# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 ChapterArray#category#[#i#] = #category#; ChapterArrayVal#category#[#i#] = #catno# #category#; /cfoutput /cfoutput // Function to populate the ATA_Sub_Codes for the ATA_Code selected function PopulateATASubCode() { // Only process the function if the first item is not selected. var indx = document.InsertForm.ATACode.selectedIndex; if (indx != 0) { // Find the Chapter var ThisChapter = document.InsertForm.ATACode[indx].value; // Set the length of the ATA_Sub_Codes drop down equal to the length of the Chapter's array var len; len = eval(ChapterArray + ThisChapter + .length); document.InsertForm.ATA_SubCode.length = len; // Put 'Select' as the first option in the SubCode drop-down document.InsertForm.ATA_SubCode[0].value = ; document.InsertForm.ATA_SubCode[0].text = Select ATA Sub Code; document.InsertForm.ATA_SubCode[0].selected = true; // Loop through the chapter's array and populate the SubCode drop down. for (i=1; ilen; i++) { document.InsertForm.ATA_SubCode.value = eval(ChapterArray + ThisChapter + ); document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal + ThisChapter + ); } } } //-- /script html head titleRequirements Database Add Requirement/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body form action=cfoutput#CurrentPage#/cfoutput method=POST name=InsertForm id=InsertForm table tr td select name=ATACode onChange=PopulateATASubCode(); option value=0Select ATA Code cfoutput query=rsATA1 group=category option value=#ATA_Chapter##category# /cfoutput /select select name=ATA_SubCode size=1 option value=0Select ATA Sub Code /select/td /tr /table /body /html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Loop Errors
Well for a start you dont neet to nest the cfoutput's Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 06 January 2003 15:50 To: CF-Talk Subject: Loop Errors Does anybody have any ideas on why I am getting a loop error from my code below I cant see why this is happening, any suggestions would be most helpful thanks... Error Occurred While Processing Request Error Diagnostic Information Loop error The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (23:1) to (23:42). Date/Time: Mon Jan 06 15:49:37 2003 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address: 121.100.25.2 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body !--- Select the ATA_Chapter, ATA_Section and title_Codes. --- cfquery name=rsquery1 datasource=intranetv8 SELECT a.category, a.catno, a.parent_level, b.category, b.catno, b.parent_level FROM category_menu a, category_menu b WHERE a.parent_level = b.catno ORDER BY a.category, b.category /cfquery !--- Select all the sub codes. --- script language = JavaScript !-- // For each chapter, create an array to hold the sections. // Each chapter array will be identified by the ATA_Chapter cfoutput query=rsATA1 group=category // Create the array ChapterArray#category# = new Array(); ChapterArrayVal#category# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 ChapterArray#category#[#i#] = #category#; ChapterArrayVal#category#[#i#] = #catno# #category#; /cfoutput /cfoutput // Function to populate the ATA_Sub_Codes for the ATA_Code selected function PopulateATASubCode() { // Only process the function if the first item is not selected. var indx = document.InsertForm.ATACode.selectedIndex; if (indx != 0) { // Find the Chapter var ThisChapter = document.InsertForm.ATACode[indx].value; // Set the length of the ATA_Sub_Codes drop down equal to the length of the Chapter's array var len; len = eval(ChapterArray + ThisChapter + .length); document.InsertForm.ATA_SubCode.length = len; // Put 'Select' as the first option in the SubCode drop-down document.InsertForm.ATA_SubCode[0].value = ; document.InsertForm.ATA_SubCode[0].text = Select ATA Sub Code; document.InsertForm.ATA_SubCode[0].selected = true; // Loop through the chapter's array and populate the SubCode drop down. for (i=1; ilen; i++) { document.InsertForm.ATA_SubCode.value = eval(ChapterArray + ThisChapter + ); document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal + ThisChapter + ); } } } //-- /script html head titleRequirements Database Add Requirement/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body form action=cfoutput#CurrentPage#/cfoutput method=POST name=InsertForm id=InsertForm table tr td select name=ATACode onChange=PopulateATASubCode(); option value=0Select ATA Code cfoutput query=rsATA1 group=category option value=#ATA_Chapter##category# /cfoutput /select select name=ATA_SubCode size=1 option value=0Select ATA Sub Code /select/td /tr /table /body /html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Loop Errors
I beleive that you have referenced the query wrong. Try: cfoutput query=rsquery1 group=category Jeff - Original Message - From: Ian Vaughan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 06, 2003 8:50 AM Subject: Loop Errors Does anybody have any ideas on why I am getting a loop error from my code below I cant see why this is happening, any suggestions would be most helpful thanks... Error Occurred While Processing Request Error Diagnostic Information Loop error The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (23:1) to (23:42). Date/Time: Mon Jan 06 15:49:37 2003 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address: 121.100.25.2 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body !--- Select the ATA_Chapter, ATA_Section and title_Codes. --- cfquery name=rsquery1 datasource=intranetv8 SELECT a.category, a.catno, a.parent_level, b.category, b.catno, b.parent_level FROM category_menu a, category_menu b WHERE a.parent_level = b.catno ORDER BY a.category, b.category /cfquery !--- Select all the sub codes. --- script language = JavaScript !-- // For each chapter, create an array to hold the sections. // Each chapter array will be identified by the ATA_Chapter cfoutput query=rsATA1 group=category // Create the array ChapterArray#category# = new Array(); ChapterArrayVal#category# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 ChapterArray#category#[#i#] = #category#; ChapterArrayVal#category#[#i#] = #catno# #category#; /cfoutput /cfoutput // Function to populate the ATA_Sub_Codes for the ATA_Code selected function PopulateATASubCode() { // Only process the function if the first item is not selected. var indx = document.InsertForm.ATACode.selectedIndex; if (indx != 0) { // Find the Chapter var ThisChapter = document.InsertForm.ATACode[indx].value; // Set the length of the ATA_Sub_Codes drop down equal to the length of the Chapter's array var len; len = eval(ChapterArray + ThisChapter + .length); document.InsertForm.ATA_SubCode.length = len; // Put 'Select' as the first option in the SubCode drop-down document.InsertForm.ATA_SubCode[0].value = ; document.InsertForm.ATA_SubCode[0].text = Select ATA Sub Code; document.InsertForm.ATA_SubCode[0].selected = true; // Loop through the chapter's array and populate the SubCode drop down. for (i=1; ilen; i++) { document.InsertForm.ATA_SubCode.value = eval(ChapterArray + ThisChapter + ); document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal + ThisChapter + ); } } } //-- /script html head titleRequirements Database Add Requirement/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body form action=cfoutput#CurrentPage#/cfoutput method=POST name=InsertForm id=InsertForm table tr td select name=ATACode onChange=PopulateATASubCode(); option value=0Select ATA Code cfoutput query=rsATA1 group=category option value=#ATA_Chapter##category# /cfoutput /select select name=ATA_SubCode size=1 option value=0Select ATA Sub Code /select/td /tr /table /body /html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Loop Errors
You have a set of nested cfoutput tags. you don't need the inner set. cfoutput cfset i = i + 1 ChapterArray#category#[#i#] = #category#; ChapterArrayVal#category#[#i#] = #catno# #category#; /cfoutput /cfoutput Also, you are getting a variable from category from 2 different dbs in your query, and returning both as category. How are you going to distinguish between these tow columns? Don't you want to name one differently? (Also true for catno and parent_level) SELECT a.category, a.catno, a.parent_level, b.category, b.catno, b.parent_level FROM category_menu a, category_menu b Jerry Johnson ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Loop Errors
The CFOUTPUT tag is referencing a non-existent query. It's referring to a query named rsATA1 while the CFQUERY names its query rsquery1. Maybe that's it? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 10:50 AM To: CF-Talk Subject: Loop Errors Does anybody have any ideas on why I am getting a loop error from my code below I cant see why this is happening, any suggestions would be most helpful thanks... Error Occurred While Processing Request Error Diagnostic Information Loop error The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (23:1) to (23:42). Date/Time: Mon Jan 06 15:49:37 2003 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address: 121.100.25.2 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body !--- Select the ATA_Chapter, ATA_Section and title_Codes. --- cfquery name=rsquery1 datasource=intranetv8 SELECT a.category, a.catno, a.parent_level, b.category, b.catno, b.parent_level FROM category_menu a, category_menu b WHERE a.parent_level = b.catno ORDER BY a.category, b.category /cfquery !--- Select all the sub codes. --- script language = JavaScript !-- // For each chapter, create an array to hold the sections. // Each chapter array will be identified by the ATA_Chapter cfoutput query=rsATA1 group=category // Create the array ChapterArray#category# = new Array(); ChapterArrayVal#category# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 ChapterArray#category#[#i#] = #category#; ChapterArrayVal#category#[#i#] = #catno# #category#; /cfoutput /cfoutput // Function to populate the ATA_Sub_Codes for the ATA_Code selected function PopulateATASubCode() { // Only process the function if the first item is not selected. var indx = document.InsertForm.ATACode.selectedIndex; if (indx != 0) { // Find the Chapter var ThisChapter = document.InsertForm.ATACode[indx].value; // Set the length of the ATA_Sub_Codes drop down equal to the length of the Chapter's array var len; len = eval(ChapterArray + ThisChapter + .length); document.InsertForm.ATA_SubCode.length = len; // Put 'Select' as the first option in the SubCode drop-down document.InsertForm.ATA_SubCode[0].value = ; document.InsertForm.ATA_SubCode[0].text = Select ATA Sub Code; document.InsertForm.ATA_SubCode[0].selected = true; // Loop through the chapter's array and populate the SubCode drop down. for (i=1; ilen; i++) { document.InsertForm.ATA_SubCode.value = eval(ChapterArray + ThisChapter + ); document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal + ThisChapter + ); } } } //-- /script html head titleRequirements Database Add Requirement/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body form action=cfoutput#CurrentPage#/cfoutput method=POST name=InsertForm id=InsertForm table tr td select name=ATACode onChange=PopulateATASubCode(); option value=0Select ATA Code cfoutput query=rsATA1 group=category option value=#ATA_Chapter##category# /cfoutput /select select name=ATA_SubCode size=1 option value=0Select ATA Sub Code /select/td /tr /table /body /html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Loop Errors
Thanks For the replies Taking them in no particular order Jason Lees said Well for a start you dont neet to nest the cfoutput's Why don't I need to nest the cfoutputs? Jeff Garza and Mosh Teitelbaum picked up on the same point, jeff said.. I beleive that you have referenced the query wrong. Try: cfoutput query=rsquery1 group=category I know what you are saying however, the query is linked to the output of the actual select shown below option value=0Select ATA Code cfoutput query=rsATA1 group=category option value=#ATA_Chapter##category# /cfoutput If you look at my code you should see this.. Jerry Johnson said cfoutput cfset i = i + 1 ChapterArray#category#[#i#] = #category#; ChapterArrayVal#category#[#i#] = #catno# #category#; /cfoutput /cfoutput why do you think I dont need this?? The code I am using is based on the code below , which works but I think they were using two tables I am only using one table?? From this you may be able to solve some of these problems??? ---ORIGINAL-- !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body !--- Select the ATA_Chapter, ATA_Section and title_Codes. --- cfquery name=rsquery1 datasource=ATA SELECT a.ata_chapter, a.ata_title, b.ata_section, b.ATA_TITLE SubTitle FROM ata_codes a, ata_sub_codes b WHERE a.ata_chapter = b.ata_chapter ORDER BY a.ata_chapter, b.ata_section /cfquery !--- Select all the sub codes. --- script language = JavaScript !-- // For each chapter, create an array to hold the sections. // Each chapter array will be identified by the ATA_Chapter cfoutput query=rsATA1 group=ATA_Chapter // Create the array ChapterArray#ATA_Chapter# = new Array(); ChapterArrayVal#ATA_Chapter# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 ChapterArray#ATA_Chapter#[#i#] = #ATA_Chapter#; ChapterArrayVal#ATA_Chapter#[#i#] = #ata_section# #SubTitle#; /cfoutput /cfoutput // Function to populate the ATA_Sub_Codes for the ATA_Code selected function PopulateATASubCode() { // Only process the function if the first item is not selected. var indx = document.InsertForm.ATACode.selectedIndex; if (indx != 0) { // Find the Chapter var ThisChapter = document.InsertForm.ATACode[indx].value; // Set the length of the ATA_Sub_Codes drop down equal to the length of the Chapter's array var len; len = eval(ChapterArray + ThisChapter + .length); document.InsertForm.ATA_SubCode.length = len; // Put 'Select' as the first option in the SubCode drop-down document.InsertForm.ATA_SubCode[0].value = ; document.InsertForm.ATA_SubCode[0].text = Select ATA Sub Code; document.InsertForm.ATA_SubCode[0].selected = true; // Loop through the chapter's array and populate the SubCode drop down. for (i=1; ilen; i++) { document.InsertForm.ATA_SubCode.value = eval(ChapterArray + ThisChapter + ); document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal + ThisChapter + ); } } } //-- /script html head titleRequirements Database Add Requirement/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body form action=cfoutput#CurrentPage#/cfoutput method=POST name=InsertForm id=InsertForm table tr td select name=ATACode onChange=PopulateATASubCode(); option value=0Select ATA Code cfoutput query=rsATA1 group=ATA_Chapter option value=#ATA_Chapter##ATA_Chapter# #ATA_Title# /cfoutput /select select name=ATA_SubCode size=1 option value=0Select ATA Sub Code /select/td /tr /table /body /html - Original Message - From: Jason Lees (National Express) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 06, 2003 3:55 PM Subject: RE: Loop Errors Well for a start you dont neet to nest the cfoutput's Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 06 January 2003 15:50 To: CF-Talk Subject: Loop Errors Does anybody have any ideas on why I am getting a loop error from my code below I cant see why this is happening, any suggestions would be most helpful thanks... Error Occurred While Processing Request Error Diagnostic Information Loop error The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (23:1) to (23:42). Date/Time: Mon Jan 06 15:49:37 2003 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address: 121.100.25.2 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body !--- Select the ATA_Chapter, ATA_Section and title_Codes. --- cfquery name=rsquery1 datasource=intranetv8 SELECT a.category, a.catno, a.parent_level, b.category, b.catno, b.parent_level FROM category_menu a, category_menu b WHERE a.parent_level = b.catno ORDER BY a.category, b.category /cfquery !--- Select all the sub codes. --- script language = JavaScript !-- // For each
RE: Loop Errors
the simple answer about the nested cfoutput tags is whats the point? and so the parser catches the nested cfoutput tags as a coding error. Its like doing cfoutput #myVar1# cfoutput #MyVar2# /cfoutput /cfoutput Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 06 January 2003 16:25 To: CF-Talk Subject: Re: Loop Errors Thanks For the replies Taking them in no particular order Jason Lees said Well for a start you dont neet to nest the cfoutput's Why don't I need to nest the cfoutputs? Jeff Garza and Mosh Teitelbaum picked up on the same point, jeff said.. I beleive that you have referenced the query wrong. Try: cfoutput query=rsquery1 group=category I know what you are saying however, the query is linked to the output of the actual select shown below option value=0Select ATA Code cfoutput query=rsATA1 group=category option value=#ATA_Chapter##category# /cfoutput If you look at my code you should see this.. Jerry Johnson said cfoutput cfset i = i + 1 ChapterArray#category#[#i#] = #category#; ChapterArrayVal#category#[#i#] = #catno# #category#; /cfoutput /cfoutput why do you think I dont need this?? The code I am using is based on the code below , which works but I think they were using two tables I am only using one table?? From this you may be able to solve some of these problems??? ---ORIGINAL-- !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body !--- Select the ATA_Chapter, ATA_Section and title_Codes. --- cfquery name=rsquery1 datasource=ATA SELECT a.ata_chapter, a.ata_title, b.ata_section, b.ATA_TITLE SubTitle FROM ata_codes a, ata_sub_codes b WHERE a.ata_chapter = b.ata_chapter ORDER BY a.ata_chapter, b.ata_section /cfquery !--- Select all the sub codes. --- script language = JavaScript !-- // For each chapter, create an array to hold the sections. // Each chapter array will be identified by the ATA_Chapter cfoutput query=rsATA1 group=ATA_Chapter // Create the array ChapterArray#ATA_Chapter# = new Array(); ChapterArrayVal#ATA_Chapter# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 ChapterArray#ATA_Chapter#[#i#] = #ATA_Chapter#; ChapterArrayVal#ATA_Chapter#[#i#] = #ata_section# #SubTitle#; /cfoutput /cfoutput // Function to populate the ATA_Sub_Codes for the ATA_Code selected function PopulateATASubCode() { // Only process the function if the first item is not selected. var indx = document.InsertForm.ATACode.selectedIndex; if (indx != 0) { // Find the Chapter var ThisChapter = document.InsertForm.ATACode[indx].value; // Set the length of the ATA_Sub_Codes drop down equal to the length of the Chapter's array var len; len = eval(ChapterArray + ThisChapter + .length); document.InsertForm.ATA_SubCode.length = len; // Put 'Select' as the first option in the SubCode drop-down document.InsertForm.ATA_SubCode[0].value = ; document.InsertForm.ATA_SubCode[0].text = Select ATA Sub Code; document.InsertForm.ATA_SubCode[0].selected = true; // Loop through the chapter's array and populate the SubCode drop down. for (i=1; ilen; i++) { document.InsertForm.ATA_SubCode.value = eval(ChapterArray + ThisChapter + ); document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal + ThisChapter + ); } } } //-- /script html head titleRequirements Database Add Requirement/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body form action=cfoutput#CurrentPage#/cfoutput method=POST name=InsertForm id=InsertForm table tr td select name=ATACode onChange=PopulateATASubCode(); option value=0Select ATA Code cfoutput query=rsATA1 group=ATA_Chapter option value=#ATA_Chapter##ATA_Chapter# #ATA_Title# /cfoutput /select select name=ATA_SubCode size=1 option value=0Select ATA Sub Code /select/td /tr /table /body /html - Original Message - From: Jason Lees (National Express) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 06, 2003 3:55 PM Subject: RE: Loop Errors Well for a start you dont neet to nest the cfoutput's Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 06 January 2003 15:50 To: CF-Talk Subject: Loop Errors Does anybody have any ideas on why I am getting a loop error from my code below I cant see why this is happening, any suggestions would be most helpful thanks... Error Occurred While Processing Request Error Diagnostic Information Loop error The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (23:1) to (23:42). Date/Time: Mon Jan 06 15:49:37 2003 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address: 121.100.25.2 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head
Re: Loop Errors
Ian, [EMAIL PROTECTED] 01/06/03 11:24AM Jerry Johnson said cfoutput cfset i = i + 1 ChapterArray#category#[#i#] = #category#; ChapterArrayVal#category#[#i#] = #catno# #category#; /cfoutput /cfoutput why do you think I dont need this?? Because the inner-most cfoutput is just being used simply to output the #variables#. The outer-most cfoutput (with the query and group attributes) does this as well, so the inner-most cfoutput is unneccessary. If the inner-most query were being used to loop through a queryset, then it would be useful. But since it is not, it can be removed. And if it can be removed, it should be removed. Jerry Why don't I need to nest the cfoutputs? Jeff Garza and Mosh Teitelbaum picked up on the same point, jeff said.. I beleive that you have referenced the query wrong. Try: cfoutput query=rsquery1 group=category I know what you are saying however, the query is linked to the output of the actual select shown below option value=0Select ATA Code cfoutput query=rsATA1 group=category option value=#ATA_Chapter##category# /cfoutput If you look at my code you should see this.. Jerry Johnson said cfoutput cfset i = i + 1 ChapterArray#category#[#i#] = #category#; ChapterArrayVal#category#[#i#] = #catno# #category#; /cfoutput /cfoutput why do you think I dont need this?? The code I am using is based on the code below , which works but I think they were using two tables I am only using one table?? From this you may be able to solve some of these problems??? ---ORIGINAL-- !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body !--- Select the ATA_Chapter, ATA_Section and title_Codes. --- cfquery name=rsquery1 datasource=ATA SELECT a.ata_chapter, a.ata_title, b.ata_section, b.ATA_TITLE SubTitle FROM ata_codes a, ata_sub_codes b WHERE a.ata_chapter = b.ata_chapter ORDER BY a.ata_chapter, b.ata_section /cfquery !--- Select all the sub codes. --- script language = JavaScript !-- // For each chapter, create an array to hold the sections. // Each chapter array will be identified by the ATA_Chapter cfoutput query=rsATA1 group=ATA_Chapter // Create the array ChapterArray#ATA_Chapter# = new Array(); ChapterArrayVal#ATA_Chapter# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 ChapterArray#ATA_Chapter#[#i#] = #ATA_Chapter#; ChapterArrayVal#ATA_Chapter#[#i#] = #ata_section# #SubTitle#; /cfoutput /cfoutput // Function to populate the ATA_Sub_Codes for the ATA_Code selected function PopulateATASubCode() { // Only process the function if the first item is not selected. var indx = document.InsertForm.ATACode.selectedIndex; if (indx != 0) { // Find the Chapter var ThisChapter = document.InsertForm.ATACode[indx].value; // Set the length of the ATA_Sub_Codes drop down equal to the length of the Chapter's array var len; len = eval(ChapterArray + ThisChapter + .length); document.InsertForm.ATA_SubCode.length = len; // Put 'Select' as the first option in the SubCode drop-down document.InsertForm.ATA_SubCode[0].value = ; document.InsertForm.ATA_SubCode[0].text = Select ATA Sub Code; document.InsertForm.ATA_SubCode[0].selected = true; // Loop through the chapter's array and populate the SubCode drop down. for (i=1; ilen; i++) { document.InsertForm.ATA_SubCode.value = eval(ChapterArray + ThisChapter + ); document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal + ThisChapter + ); } } } //-- /script html head titleRequirements Database Add Requirement/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body form action=cfoutput#CurrentPage#/cfoutput method=POST name=InsertForm id=InsertForm table tr td select name=ATACode onChange=PopulateATASubCode(); option value=0Select ATA Code cfoutput query=rsATA1 group=ATA_Chapter option value=#ATA_Chapter##ATA_Chapter# #ATA_Title# /cfoutput /select select name=ATA_SubCode size=1 option value=0Select ATA Sub Code /select/td /tr /table /body /html - Original Message - From: Jason Lees (National Express) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 06, 2003 3:55 PM Subject: RE: Loop Errors Well for a start you dont neet to nest the cfoutput's Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 06 January 2003 15:50 To: CF-Talk Subject: Loop Errors Does anybody have any ideas on why I am getting a loop error from my code below I cant see why this is happening, any suggestions would be most helpful thanks... Error Occurred While Processing Request Error Diagnostic Information Loop error The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (23:1) to (23:42). Date/Time: Mon Jan 06 15:49:37 2003 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) Remote Address
RE: Loop Errors
but strangely enough, cfmx doesn't barf on nested cfoutputs. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 11:41 AM To: CF-Talk Subject: RE: Loop Errors the simple answer about the nested cfoutput tags is whats the point? and so the parser catches the nested cfoutput tags as a coding error. Its like doing cfoutput #myVar1# cfoutput #MyVar2# /cfoutput /cfoutput Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 06 January 2003 16:25 To: CF-Talk Subject: Re: Loop Errors Thanks For the replies Taking them in no particular order Jason Lees said Well for a start you dont neet to nest the cfoutput's Why don't I need to nest the cfoutputs? Jeff Garza and Mosh Teitelbaum picked up on the same point, jeff said.. I beleive that you have referenced the query wrong. Try: cfoutput query=rsquery1 group=category I know what you are saying however, the query is linked to the output of the actual select shown below option value=0Select ATA Code cfoutput query=rsATA1 group=category option value=#ATA_Chapter##category# /cfoutput If you look at my code you should see this.. Jerry Johnson said cfoutput cfset i = i + 1 ChapterArray#category#[#i#] = #category#; ChapterArrayVal#category#[#i#] = #catno# #category#; /cfoutput /cfoutput why do you think I dont need this?? The code I am using is based on the code below , which works but I think they were using two tables I am only using one table?? From this you may be able to solve some of these problems??? ---ORIGINAL-- !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body !--- Select the ATA_Chapter, ATA_Section and title_Codes. --- cfquery name=rsquery1 datasource=ATA SELECT a.ata_chapter, a.ata_title, b.ata_section, b.ATA_TITLE SubTitle FROM ata_codes a, ata_sub_codes b WHERE a.ata_chapter = b.ata_chapter ORDER BY a.ata_chapter, b.ata_section /cfquery !--- Select all the sub codes. --- script language = JavaScript !-- // For each chapter, create an array to hold the sections. // Each chapter array will be identified by the ATA_Chapter cfoutput query=rsATA1 group=ATA_Chapter // Create the array ChapterArray#ATA_Chapter# = new Array(); ChapterArrayVal#ATA_Chapter# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 ChapterArray#ATA_Chapter#[#i#] = #ATA_Chapter#; ChapterArrayVal#ATA_Chapter#[#i#] = #ata_section# #SubTitle#; /cfoutput /cfoutput // Function to populate the ATA_Sub_Codes for the ATA_Code selected function PopulateATASubCode() { // Only process the function if the first item is not selected. var indx = document.InsertForm.ATACode.selectedIndex; if (indx != 0) { // Find the Chapter var ThisChapter = document.InsertForm.ATACode[indx].value; // Set the length of the ATA_Sub_Codes drop down equal to the length of the Chapter's array var len; len = eval(ChapterArray + ThisChapter + .length); document.InsertForm.ATA_SubCode.length = len; // Put 'Select' as the first option in the SubCode drop-down document.InsertForm.ATA_SubCode[0].value = ; document.InsertForm.ATA_SubCode[0].text = Select ATA Sub Code; document.InsertForm.ATA_SubCode[0].selected = true; // Loop through the chapter's array and populate the SubCode drop down. for (i=1; ilen; i++) { document.InsertForm.ATA_SubCode.value = eval(ChapterArray + ThisChapter + ); document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal + ThisChapter + ); } } } //-- /script html head titleRequirements Database Add Requirement/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body form action=cfoutput#CurrentPage#/cfoutput method=POST name=InsertForm id=InsertForm table tr td select name=ATACode onChange=PopulateATASubCode(); option value=0Select ATA Code cfoutput query=rsATA1 group=ATA_Chapter option value=#ATA_Chapter##ATA_Chapter# #ATA_Title# /cfoutput /select select name=ATA_SubCode size=1 option value=0Select ATA Sub Code /select/td /tr /table /body /html - Original Message - From: Jason Lees (National Express) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 06, 2003 3:55 PM Subject: RE: Loop Errors Well for a start you dont neet to nest the cfoutput's Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 06 January 2003 15:50 To: CF-Talk Subject: Loop Errors Does anybody have any ideas on why I am getting a loop error from my code below I cant see why this is happening, any suggestions would be most helpful thanks... Error
Re: Loop Errors
The CFOUTPUT on Line 30 is fine because it's nested under a CFOUTPUT that contains the GROUP attribute... However, both Line 24, cfoutput query=rsATA1 group=category and Line 77, option value=0Select ATA Code cfoutput query=rsATA1 group=category are in error because the query that is referenced does not exist in this template. The only query in this template is rsquery1. Also on Line 77, the CFOUTPUT should *not* contain the GROUP attribute because it's being used to populate a select, not display output by group. And...Lines 3 thru 8 contain duplicate HTML tags. ~Dina - Original Message - From: Tony Weeg To: CF-Talk Sent: Monday, January 06, 2003 10:55 AM Subject: RE: Loop Errors but strangely enough, cfmx doesn't barf on nested cfoutputs. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 11:41 AM To: CF-Talk Subject: RE: Loop Errors the simple answer about the nested cfoutput tags is whats the point? and so the parser catches the nested cfoutput tags as a coding error. Its like doing cfoutput #myVar1# cfoutput #MyVar2# /cfoutput /cfoutput Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 06 January 2003 16:25 To: CF-Talk Subject: Re: Loop Errors Thanks For the replies Taking them in no particular order Jason Lees said Well for a start you dont neet to nest the cfoutput's Why don't I need to nest the cfoutputs? Jeff Garza and Mosh Teitelbaum picked up on the same point, jeff said.. I beleive that you have referenced the query wrong. Try: cfoutput query=rsquery1 group=category I know what you are saying however, the query is linked to the output of the actual select shown below option value=0Select ATA Code cfoutput query=rsATA1 group=category option value=#ATA_Chapter##category# /cfoutput If you look at my code you should see this.. Jerry Johnson said cfoutput cfset i = i + 1 ChapterArray#category#[#i#] = #category#; ChapterArrayVal#category#[#i#] = #catno# #category#; /cfoutput /cfoutput why do you think I dont need this?? The code I am using is based on the code below , which works but I think they were using two tables I am only using one table?? From this you may be able to solve some of these problems??? ---ORIGINAL-- !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html head titleUntitled/title /head body !--- Select the ATA_Chapter, ATA_Section and title_Codes. --- cfquery name=rsquery1 datasource=ATA SELECT a.ata_chapter, a.ata_title, b.ata_section, b.ATA_TITLE SubTitle FROM ata_codes a, ata_sub_codes b WHERE a.ata_chapter = b.ata_chapter ORDER BY a.ata_chapter, b.ata_section /cfquery !--- Select all the sub codes. --- script language = JavaScript !-- // For each chapter, create an array to hold the sections. // Each chapter array will be identified by the ATA_Chapter cfoutput query=rsATA1 group=ATA_Chapter // Create the array ChapterArray#ATA_Chapter# = new Array(); ChapterArrayVal#ATA_Chapter# = new Array(); cfset i = 0 // Populate the array cfoutput cfset i = i + 1 ChapterArray#ATA_Chapter#[#i#] = #ATA_Chapter#; ChapterArrayVal#ATA_Chapter#[#i#] = #ata_section# #SubTitle#; /cfoutput /cfoutput // Function to populate the ATA_Sub_Codes for the ATA_Code selected function PopulateATASubCode() { // Only process the function if the first item is not selected. var indx = document.InsertForm.ATACode.selectedIndex; if (indx != 0) { // Find the Chapter var ThisChapter = document.InsertForm.ATACode[indx].value; // Set the length of the ATA_Sub_Codes drop down equal to the length of the Chapter's array var len; len = eval(ChapterArray + ThisChapter + .length); document.InsertForm.ATA_SubCode.length = len; // Put 'Select' as the first option in the SubCode drop-down document.InsertForm.ATA_SubCode[0].value = ; document.InsertForm.ATA_SubCode[0].text = Select ATA Sub Code; document.InsertForm.ATA_SubCode[0].selected = true; // Loop through the chapter's array and populate the SubCode drop down. for (i=1; ilen; i++) { document.InsertForm.ATA_SubCode.value = eval(ChapterArray + ThisChapter + ); document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal + ThisChapter + ); } } } //-- /script html head titleRequirements Database Add Requirement/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body form action