Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
GarryCS69 #1
CFTree generates a report
I have taken the code attached from the cf examples. I want to change it
slightly. I want to be able to select an item from the cftree and when I do the
selection a report will be generated.
So I have a database of events. The main cftree will list all events by
artist,style,date. If the user selects style I want to create a list of all
concerts, ordered by style. If I select Rock (a sub category of style) on the
cftree I will get an output list of all rock concerts. So what do I use instead
of the cfinput that is in the sample script
Thanks
Garry
Attach Code
<cfquery name="Gigs" datasource="LobbyData">
select Artist,Date,Time,MusicStyle
from AllGigsByArtist
order by Artist,Date
</cfquery>
<cfform name="form1" format="Flash" width="500" height="400">
<cfformgroup type="HBox">
<cfformgroup type="VBox">
<cftree
format="Flash"
Name="tree1"
Width="300"
Height="200"
HScroll="yes"
VScroll="yes"
Border="no"
AppendKey="yes"
lookandfeel = "motif"
bold="no"
completepath="yes"
align="left">
<cftreeitem value="Artist,Date"
display="Artist,Date"
query="Gigs"
queryasroot="By Artist"
expand="Yes,NO,NO">
<cftreeitem value="MusicStyle,Artist,Date"
display="MusicStyle,Artist,Date"
query="Gigs"
queryasroot="By Style"
expand="Yes,NO,NO">
<cftreeitem value="Date,Artist"
display="Date,Artist"
query="Gigs"
queryasroot="By Date"
expand="Yes,NO,NO">
</cftree>
</cfformgroup>
<cfinput type="text" name="display" label="display"
bind="{tree1.dataProvider[tree1.selectedIndex]['Artist']}">
<cfinput type="text" name="value" label="value"
bind="{tree1.selectedNode.getProperty('data').valu e('Date')}">
<cfinput type="text" name="path" label="path"
bind="{tree1.selectedNode.getProperty('data').path }">
</cfformgroup>
</cfform>
GarryCS69 Guest
-
preflight XML report differs from droplet report
Hi all, When i create a xml-report 'by hand' with the preflight tool, it generates much more info then when i use the same preflight profile as a... -
Webservice generates an error after a while
I've got a problem with a webservice. It works for a couple of days and then, all of a sudden, it stops working. It generates the "Could not... -
SWC generates server error
I've built an SWC using flash: it's an extended flex button component with a different skin animation. The button works fine in my flex... -
Debugging how ASP.NET generates controls
Hi! I have a problem that I can't seem to debug. I generate a TextBox in ASP.NET and set it's Text property to "768". I check it at the end... -
How to link 3 different combo boxex in a form (as report criteria) to the report
I would like to use 3 combo boxes in a form as parameter criteria for a report. When I open a report, there will be a pop up form with 3 combo...



Reply With Quote

