I have managed to write a flash template in CF that is dynamic. The tabs on my CF flash generated form are dynamic in that only the values from a query are used as tab names. I have managed to nest a loop query for the child tabs. These too are dynamic in that the child tabs belong to a specific parent tab and only those child tabs returned by the query are created.
My problem is that when I place the cfgrid statement inside the child tab then that is where my problem begins.
If I build the template as a single parent tab (the where clause is hard coded and has no loop) and one child tab (no loop) and place the cfgrid in the mix it works.
Can anyone tell me why the form fails to load when my cfgrid is enabled? If so how can I fix it?
Thanks
Jim
Here is my code so far.
<!---
Name: ruledownloadform.cfm
Author: James Schell
Description: Download form for rules based on a query
Created: 05/19/07
--->
<!--- Query for Parent tabs --->
<cfquery name = "GetParentTab" dataSource = "rules">
SELECT RMSTab
from Rules
group by rmstab
</cfquery>
<!--- Begin creating flash tab form --->
<cfform format="flash">
<!--- Insert tab control --->
<cfformgroup type="tabnavigator" query="GetParentTab" visible="yes" enabled="yes">
<!--- Create loop query to get parent tab names --->
<cfloop query="GetParentTab">
<!--- Create parent tabs based on return from GetParentTab query --->
<cfformgroup type="page" label="#RMSTab#">
<!--- Create sub tab control --->
<cfformgroup type="tabnavigator">
<!--- Query for Sub tabs --->
<cfquery name = "GetChildTab" dataSource = "rules">
SELECT RMSSubTab, RMSTab
from Rules
where '#GetParentTab.RMSTab#' = RMSTab
group by rmssubtab,rmstab
</cfquery>
<!--- Create loop query to get sub tab names --->
<cfloop query="GetChildTab">
<!--- Create sub tabs based on return from GetSubTab query --->
<cfformgroup type="page" Label="#Getchildtab.RMSSUBTAB#">
<!--- Query for Rules --->
<cfquery name="GetRules" datasource="rules">
Select RuleFileName
from Rules
where '#GetChildTab.RMSSubTaB#'=RMSSubTab and '#GetChildTab.RMSTab#'=RMSTab
</cfquery>
<!---
<cfgrid name="rulegrid" format="flash" query="GetRules">
<cfgridcolumn name="rulefilename" header="Rule">
</cfgrid>
--->
</cfformgroup>
</cfloop>
</cfformgroup>
</cfformgroup>
</cfloop>
</cfformgroup>
</cfform>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
</body>
</html>
My problem is that when I place the cfgrid statement inside the child tab then that is where my problem begins.
If I build the template as a single parent tab (the where clause is hard coded and has no loop) and one child tab (no loop) and place the cfgrid in the mix it works.
Can anyone tell me why the form fails to load when my cfgrid is enabled? If so how can I fix it?
Thanks
Jim
Here is my code so far.
<!---
Name: ruledownloadform.cfm
Author: James Schell
Description: Download form for rules based on a query
Created: 05/19/07
--->
<!--- Query for Parent tabs --->
<cfquery name = "GetParentTab" dataSource = "rules">
SELECT RMSTab
from Rules
group by rmstab
</cfquery>
<!--- Begin creating flash tab form --->
<cfform format="flash">
<!--- Insert tab control --->
<cfformgroup type="tabnavigator" query="GetParentTab" visible="yes" enabled="yes">
<!--- Create loop query to get parent tab names --->
<cfloop query="GetParentTab">
<!--- Create parent tabs based on return from GetParentTab query --->
<cfformgroup type="page" label="#RMSTab#">
<!--- Create sub tab control --->
<cfformgroup type="tabnavigator">
<!--- Query for Sub tabs --->
<cfquery name = "GetChildTab" dataSource = "rules">
SELECT RMSSubTab, RMSTab
from Rules
where '#GetParentTab.RMSTab#' = RMSTab
group by rmssubtab,rmstab
</cfquery>
<!--- Create loop query to get sub tab names --->
<cfloop query="GetChildTab">
<!--- Create sub tabs based on return from GetSubTab query --->
<cfformgroup type="page" Label="#Getchildtab.RMSSUBTAB#">
<!--- Query for Rules --->
<cfquery name="GetRules" datasource="rules">
Select RuleFileName
from Rules
where '#GetChildTab.RMSSubTaB#'=RMSSubTab and '#GetChildTab.RMSTab#'=RMSTab
</cfquery>
<!---
<cfgrid name="rulegrid" format="flash" query="GetRules">
<cfgridcolumn name="rulefilename" header="Rule">
</cfgrid>
--->
</cfformgroup>
</cfloop>
</cfformgroup>
</cfformgroup>
</cfloop>
</cfformgroup>
</cfform>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
</body>
</html>