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
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
