Kim, try this and see what happens: - <cfoutput query="currentQuery"> <tr>
<td align="center" class="contentsmall"><b>#repVol</b></td> <td align="center" class="contentsmall"><b>#repIssue#</b></td> <td align="center" class="contentsmall"><b>#DateFormat(reportDate,"mmmm d,yyyy")#</b></td> <tr> </cfoutput> Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper <Web Application Specialists> -----Original Message----- From: Kim M. Inganamort [mailto:[EMAIL PROTECTED] Sent: Saturday, July 05, 2003 5:32 PM To: CF-Talk Subject: please help me with cfoutput Below is an exerpt of my code that is applicable. Whats weird is that the first cfoutput gives me an error, "repvol is undefined", and the second cfoutput works (of course I have to rid the first one to see so that it will process the second). Both are working valid fields in my db. I don't understand why it wont work for cfvol. It also wont work when I tried it on repIssue. Though there is data in those fields on the most recent record. Ive been sitting here for hours trying to make this work. Im a little new at this, so excuse me. Any help is much much appreciated! Thanks! ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ <cfquery name="maxidQuery" datasource="commodityHistory"> SELECT MAX(ID) as currentRecord FROM price </cfquery> <cfoutput query="maxidQuery"> <cfquery name="currentQuery" datasource="commodityHistory"> SELECT * FROM price WHERE ID = #currentRecord# </cfquery> </cfoutput> <table width="562" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="562"> <table border="0" cellpadding="3" cellspacing="0" width="562" align="center"> <tr> <td class="tbl" colspan="3" align="center"><font class="pageheader">THE WEEKLY COMMODITY REPORT</font><br><font class="contentsmall">American Restaurant Association Inc. Providing Food-Commodity Market Information to over 200,000 Food Service Professionals Nationwide. <a href="http://www.AmericanRestaurantAssociation.com"; target="_blank"></a>www.AmericanRestaurantAssociation.com</a></font></td > </tr> <tr> <td align="center" class="contentsmall"><b><cfoutput query="currentQuery">#currentQuery.repVol#</cfoutput></b></td> <td align="center" class="contentsmall"><b>#currentQuery.repIssue#</b></td> <td align="center" class="contentsmall"><b><cfoutput query="currentQuery">#DateFormat(reportDate,"mmmm d, yyyy")#</cfoutput></b></td> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
