I am trying really hard to stay within the confines of the FuseBox
methodology, but I am having problems getting a variable to pass to an
include. I want to stick with keeping my queries in there own files but one
of those queries I don't know the values until runtime. So I created a
cfloop with the first recordset and try to pass each of the records to the
other query as a variable. Maybe it will be clearer from the code:
<cfloop query="GetDocCategories" startrow="1"
endrow="#GetDocCategories.recordcount#">
<li class="litem">
<a
href="index.cfm?fuseaction=viewcatdocs&cat=#GetDocCategories.CATEGORY#">
<cfoutput>#GetDocCategories.CATEGORY#</cfoutput></a>
<cfset attribute.category = #GetDocCategories.CATEGORY#>
<cfinclude template="/myfuse/qry_docscat.cfm">
<cfoutput query="CountNewDocs">
#CountNewDocs.TOTAL#
</cfoutput>
</cfloop>
When the page runs (with debugging) I get this query printout:
CountNewDocs (Records=1, Time=0ms)
SQL =
SELECT COUNT(*) AS TOTAL
FROM dbo.DOCS
WHERE ((CATEGORY = '')
AND (DATEUPDATED > DATEADD(MONTH, -1 , GETDATE())))
Maybe this is something simple that I have over looked, but I can't figure
it out.
Can someone help?
Thanks.
____________________________________________
Julian Easterling, Systems Developer
The CDM Group, Inc.
5530 Wisconsin Ave, Suite 1600
Chevy Chase, MD 20815
(301) 654-6740
jeasterling @ cdmgroup.com
A journey of a thousand miles begin with a single step.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
