The name attribute of the <cfquery> tag is "queryname" not "progress_report" so the error makes sense. Make sure the query attribute of <cfoutput> and the name attribute of <cfquery> match.
-Matt > -----Original Message----- > From: Cecilia Shaw [mailto:[EMAIL PROTECTED]] > Sent: Sunday, May 05, 2002 6:04 PM > To: CF-Talk > Subject: RE: SQL Statement > > YES! That is why this is so confusing to me. I revised the statement > and here is what I have: > > <CFIF IsDefined("URL.ID")> > <CFQUERY NAME="queryname" DATASOURCE="#db#"> > SELECT contact.contact_key, progress.* > FROM contact,progress > WHERE contact.contact_key = progress.contact_key > AND contact.contact_key = #SESSION.member_contact_key# > ADN contact.contact_key = #URL.contact_key# > </cfquery> > </cfif> > <cfoutput query="progress_report"> > > This is the error I am getting: > > Error Diagnostic Information > QUERY > > The QUERY attribute of the tag does not specify the name of an available > query > > The error occurred while processing an element with a general identifier > of > (CFOUTPUT), occupying document position (75:1) to (75:34). > > ======= > Any suggestions? > > > ================ > >From: "Matt Liotta" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: CF-Talk <[EMAIL PROTECTED]> > >Subject: RE: SQL Statement > >Date: Sun, 5 May 2002 17:52:14 -0700 > > > >Are you not running CF 5? > > > >-Matt > > > > > -----Original Message----- > > > From: Cecilia Shaw [mailto:[EMAIL PROTECTED]] > > > Sent: Sunday, May 05, 2002 5:47 PM > > > To: CF-Talk > > > Subject: RE: SQL Statement > > > > > > Now I'm getting an error message: > > > > > > ColdFusion cannot determine how to process the tag <CFDUMP>. The tag > >name > > > may be misspelled. > > > > > > If you are using tags whose names begin with CF but are not ColdFusion > > > tags > > > you should contact Allaire Support. > > > > > > > > > The error occurred while processing an element with a general > >identifier > > > of > > > (CFDUMP), occupying document position (30:2) to (30:33). > > > > > > Still unsure about this. > > > > > > >From: "Matthew Walker" <[EMAIL PROTECTED]> > > > >Reply-To: [EMAIL PROTECTED] > > > >To: CF-Talk <[EMAIL PROTECTED]> > > > >Subject: RE: SQL Statement > > > >Date: Mon, 6 May 2002 11:41:43 +1200 > > > > > > > >Have you tried <cfdump var="#queryname#"> ? > > > > > > > >Also you don't need a datasource in a cfoutput. > > > > > > > >-----Original Message----- > > > >From: Cecilia Shaw [mailto:[EMAIL PROTECTED]] > > > >Sent: Monday, 6 May 2002 11:28 a.m. > > > >To: CF-Talk > > > >Subject: re: SQL Statement > > > > > > > > > > > >I have a SQL statement that is returning a blank page. The query is > >as > > > >follows: > > > > > > > ><CFIF IsDefined("URL.ID")> > > > > <CFQUERY NAME="queryname" DATASOURCE="#db#"> > > > > SELECT contact.contact_key, progress.* > > > > FROM contact,progress > > > > WHERE contact.contact_key = progress.contact_key > > > > AND contact.contact_key = #SESSION.memberID# > > > > ADN contact.contact_key = #URL.ID# > > > > </cfquery> > > > ></cfif> > > > > > > > ><cfoutput query="queryname" Datasource=#db#> > > > ><table border="0" cellpadding="3" cellspacing="3"> > > > ><th align="left" colspan="3" bgcolor="006951"> > > > ><font color="White"> > > > >Here are the current progress tracker scores for: > > > >#URL.contact_key#</font></th> > > > > > > > > > > > ><tr bgcolor="E5E5E5"><td align="right" valign="top">Planks:</td> > > > ><td align="left" valign="top" colspan="2"> > > > >Minutes: #plank_min#<br> > > > >Seconds: #plank_sec#<br> > > > ><strong>Total Points for Planks: > >#plank_pts#</strong></td></tr></table> > > > ></cfoutput> > > > > > > > >At a loss, please help!! > > > > > > > > > > > > > > > > > > > >Cecilia Jimason Shaw > > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________________________ 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 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
