RE: [flexcoders] Flex and CFCs -- problems displaying recordsets in datagrids

Thu, 21 Jul 2005 23:33:16 -0700

I think the workaround for caps was
SELECT Stuff as Stuff FROM tbl
 
Philippe Maegerman

From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Steiner
Sent: vendredi 22 juillet 2005 6:01
To: [email protected]
Subject: RE: [flexcoders] Flex and CFCs -- problems displaying recordsets in datagrids

When returning data from a CFC – most of the time it changes the name to all caps.  For example:

 

SELECT Stuff FROM Table

 

Cfreturn query

 

Output it as:

event.result[0].STUFF;

 

Jeff

Founder

Flex Authority

http://www.flexauthority.com

 

We are actively seeking contributors for the site.  Have a sample that you want to share with the world?  Send it to us!

From: [email protected] [mailto:[email protected]] On Behalf Of coldfs
Sent: Thursday, July 21, 2005 4:35 PM
To: [email protected]
Subject: [flexcoders] Flex and CFCs -- problems displaying recordsets in datagrids

 

Hi,

I'm new to Flex and have been working over the last few weeks to
integrate this product with CF.  One of my central aims is to be able
to pass data from Flex to a CFC which houses a query and will return
a recordset back to Flex.  Through piecing together examples here and
there, I've figured out how to call the CFC and send data to it from
Flex, but I've been unable to figure out how to display the recordset
in a Flex datagrid.  Any help/examples, best practices, on how to do
this would be greatly appreciated.  My existing code follows.  The
query recordset returns two fields.  The error I receive is:

1 Error found.

Error /FlexToCFC2.mxml:19
There is no property with the name 'text'.

--------------------------------------------------


<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.macromedia.com/2003/mxml"
xmlns="*">

      <mx:Script>
      <![CDATA[
           
            private function doClick():Void{
                  ro.GetUpdateAuthorization(input.text);
            }
           
            private function doResult(event:Object):Void{
                  output.text = event.result;
            }
           
            private function doFault(event:Object):Void{
                  alert("Error invoking CF: " +
event.fault.faultstring);
            }
           
      ]]>
      </mx:Script>
     
      <mx:RemoteObject id="ro"
endpoint="http://gx270dev.childsupport.net/flashservices/gateway"
           
      source="Model.mUtilities.mUpdate.qry_UpdateAuthorization"
                  fault="doFault(event)"
                  result="doResult(event)">

      </mx:RemoteObject>
     
      <mx:Panel title="Updates">
            <mx:Form defaultButton="sendButton">
                  <mx:FormItem label="Input:"
direction="horizontal">
                        <mx:TextInput id="input"/>
                        <mx:Button id="sendButton"
label="Send" click="doClick()"/>
                  </mx:FormItem>
                  <mx:DataGrid id="output" width="520"
wordWrap="true">
                    <mx:columns>
                      <mx:Array>
                        <mx:DataGridColumn width="200"
headerText="Update Form" columnName="Function"/>
                          <mx:DataGridColumn width="320"
headerText="Description" columnName="Description"/>
                    </mx:Array>
                  </mx:columns>
                </mx:DataGrid>
            </mx:Form>
      </mx:Panel>

</mx:Application>


Many thanks,
Darius









--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com



SPONSORED LINKS
Computer software testing Macromedia flex Development
Software developer

YAHOO! GROUPS LINKS



------------------------------------------------------------------
**STATEMENT OF CONFIDENTIALITY**

This e-mail and any attached files are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of author and do not necessarily represent those the Emakina Company. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.

We also inform you that we have checked that this message does not contain any virus but we decline any responsability in case of any damage caused by an a non detected virus.
------------------------------------------------------------------

Reply via email to