Skip to main content
C
cfnew
Known Participant
January 17, 2011
Question

need help in this plzzz

  • January 17, 2011
  • 1 reply
  • 475 views

HI ,


I am working  in coldfusion from recently . I came up with some issue today that we  had a coldfusion queries and display results in table as reports . This  is fine but now we want to change this to flash.

We had  front end designed by some one in flash and in flash window we need to  place this coldfusion report to display in flash UI Screen and it should  have to be refreshed in certain intervals to update report if there is  new records inserted in database.(its kind of issue tracing).

Our technical guys came with some ideas to implement this coldfusion queries to display in flash with two ideas.

One is that we need to make these queries to XML data feed to flash .

Second is from CFC's to flash.

I  have no idea how can do this and integrate with flash . Anyone has any  ideas on this how we can do this like by using XML data feeds and CFC's.

Please help me with simple query example to convert to XML data feed or CFC and how to display that result in flash .

Please help me

thanks.

This topic has been closed for replies.

1 reply

A
Anonymous
February 15, 2011

I'm not sure if you still need help but since this wasn't answered....

The below is the query and then the XML formatting for a web service that we use which is in a CFC.  This is more as an example of how to format XML out of a query.

         <cfquery name="qryGetGroups" datasource="#application.ams#">
                SELECT comr_id, com_name, comt_name, como_title, comr_join_dte, comr_end_dte, com_id
                FROM committeeTable
                WHERE ppl_id = #someID#
                ORDER BY com_name;
            </cfquery>
           
            <cfsavecontent variable="PersonGroupDetails">
                <groups>
                    <cfoutput query="qryGetGroups">
                        <group id="#comr_id#">
                            <GroupKey>#XMLFormat(com_id)#</GroupKey>
                            <GroupName>#XMLFormat(com_name)#</GroupName>
                            <GroupType>#XMLFormat(comt_name)#</GroupType>
                            <Role>#XMLFormat(como_title)#</Role>
                            <SinceDate>#XMLFormat(comr_join_dte)#</SinceDate>
                            <StartDate>#XMLFormat(comr_join_dte)#</StartDate>
                            <EndDate>#XMLFormat(comr_end_dte)#</EndDate>
                        </group>
                    </cfoutput>                   
                </groups>
            </cfsavecontent>

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices