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
