Yes, Thanks I just figured it out also. It was the problem with my query being the same name as the field name #lesson#
duh! Thanks guys Shawn Regan Applications Developer Pacific Technology Solutions -----Original Message----- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 2:24 PM To: CF-Talk Subject: Re: query loop error Not quite sure here, but... You have a query loop using a query named lesson. You then have an output loop with a query named #quiz_name# with a field named lesson. It may be that the inner loop can't resolve between the query lesson and the variable lesson. what if you used 1. called the outer loop something unique, like LessonQuery or 2. referenced the lesson in the output by queryname.lesson Just an idea, Jerry Johnson >>> [EMAIL PROTECTED] 04/02/02 05:10PM >>> I keep getting this error: Cannot set default query to LESSON A query by this name is not available at this time The error occurred while processing an element with a general identifier of (CFOUTPUT), occupying document position (50:2) to (50:31) in the template file I can't seem to figure it out. Big brain fart today. here is my code: <cfloop query="lesson"> <cfquery name="#quiz_name#" datasource="#DSN#" username="#username#" password="#password#"> SELECT * FROM faxdata_text where lesson like '%#trim(quiz_name)#%' </cfquery> line 50 --> <cfoutput query="#quiz_name#">#lesson#<br></cfoutput> </cfloop> TIA Shawn Regan Applications Developer Pacific Technology Solutions ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
