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 > > > > > > > > > > > ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
