What does qry_docscat.cfm look like?
in the code below you are using:
<cfset attribute.category = #GetDocCategories.CATEGORY#>
but should it be:
<cfset attributes.category = #GetDocCategories.CATEGORY#>
?
Bert
> -----Original Message-----
> From: Julian Easterling [mailto:[EMAIL PROTECTED]]
> Sent: 20 September 2000 22:02
> To: '[EMAIL PROTECTED]'
> Subject: [Fusebox] Passing variables to includes
>
>
> 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.C
> ATEGORY#">
> <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.
------------------------------------------------------------------------------
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.
