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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
