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
