Re: [flexcoders] Calling ArrayStructures in CFCs from Flex

2005-08-15 Thread Tariq Ahmed 






Absolumont!


Tracy Spratt wrote:

  
  

  Message
  
  

  
  
  I’m sure
Tarik will be happy to post
it on CFLEX.net.
  Tracy
   
  
  
  
  From: flexcoders@yahoogroups.com [mailto:flexcoders@yahoogroups.com] On Behalf Of [EMAIL PROTECTED]
  Sent: Monday, August
15, 2005 4:09
PM
  To: flexcoders@yahoogroups.com
  Subject: RE:
[flexcoders] Calling
ArrayStructures in CFCs from Flex
  
   
  
  Jeff,
  
  
   
  
  
  You were
right! The problem was that I had
to hard code my structure keys.  For example:
  
  
   
  
  
    
   
   
   
    
  
  
  
   
  
  
  I've spent
so long working out all the
details of calling a facade cfc from Flex that I want to post the
completed
solution on some blog/site having to do with Flex.  I really think
others
will benefit from a simple, straight-forward example.  Do you have any
suggestions on where to post this?
  
  
   
  
  
  Thanks again
for all your help,
  
  
  Darius
  
  








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





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "flexcoders" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

RE: [flexcoders] Calling ArrayStructures in CFCs from Flex

2005-08-15 Thread Malcolm 










Great, will definitely take a look, agreed,
we certainly need some sort of reference…The dark art of Flex & CFC’s.

 

Malcolm

 









From:
flexcoders@yahoogroups.com [mailto:flexcoders@yahoogroups.com] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, 16 August 2005 6:13
AM
To: flexcoders@yahoogroups.com
Subject: RE: [flexcoders] Calling
ArrayStructures in CFCs from Flex



 



Hi Malcolm,





 





Thanks for your advice.  Jeff's
solutions worked well if you want to take a look.  I'm going to try to
post my completed solution on some site.  





 





Darius





-Original Message-
From: flexcoders@yahoogroups.com
[mailto:flexcoders@yahoogroups.com]On Behalf Of Malcolm
Sent: Wednesday, August 10, 2005
4:48 PM
To: flexcoders@yahoogroups.com
Subject: RE: [flexcoders] Calling
ArrayStructures in CFCs from Flex

Hi Darius,

I too went through the same pain (days & days of
trying see what data types
I could successfully return from a CFC).

I'm still learning but in my somewhat limited
experience I could find no way
to return an array datatype, it just wouldn't do
it no matter what I tried,
same goes for structures. I have successfully
returned the following
datatypes:

:String
:Query
:Boolean

:Numeric (yet to try)
:Date (yet to try)

It's interesting to note that Flex (somehow) in
the background actually
converts a ColdFusion query to an array. (Search
the group on how these can
be accessed)

At the moment I am mostly using queries to get
data back. This has the
unfortunate side effect of losing typing
(everything in the query is a
string), thus you may need cast some results etc
to their correct type in
Flex.

Malcolm

-Original Message-
From: flexcoders@yahoogroups.com
[mailto:flexcoders@yahoogroups.com]
On
Behalf Of coldfs
Sent: Friday, 5 August 2005 7:29 AM
To: flexcoders@yahoogroups.com
Subject: [flexcoders] Calling ArrayStructures in
CFCs from Flex

Hi,

Using Tom Link's blog (http://tomlink.net/blog/index.cfm?
mode=entry&entry=B662BEF9-7E97-A3B0-E3FB286E23BDAA50)
and other 
sources, I've been trying for days to translate
queries to arrays of 
structures (and vice versa).  Whatever I do,
the cfc doesn't except 
my values from Flex as arrays.  I know it's a
chunk of code to 
review, but you'd help a sane man going slowly
mad...:-)

Many thanks,
Darius

---
index.mxml:
---

http://www.macromedia.com/2003/mxml">

  
 
  
  
  
  
  
endpoint="http://gx270dev.net/flashservices/gateway"

source="Model.mUtilities.mUpdate.qry_UpdateAuthorization"

fault="mx.controls.Alert.show(event.fault.faultstring)"

showBusyCursor="true">
 
  
result="doResult(event.result)"/>
 

  
  
    

wordWrap="true"
dataProvider="{RecordSetModel}">
 
   

 
   
    
 
   
   

width="200" headerText="Update
Form" columnName="Function"/>
 
   
   

width="320"
headerText="Description" columnName="Description"/>
 
   
     
 
   

 
  
   

  
  


--
fx_UpdateAuthorization.cfc
--

  
  
("component","qry_UpdateAuthorization")>
  
  
  
  
returntype="array">
 
  
type="array"
required="yes">
 
  
required="yes">
 
  
required="yes">
 
  
type="array"
required="yes">
 
  
required="yes">
 
  
(obj.GetUpdateAuthorization
(AuthorizedUserIdObject,CountyCodeObject,CaseFlagObject,CourtOrderAvai
lableFlagObject,DsnObject))>
  
  


-
qry_UpdateAuthorization.cfc
-

  
  
returntype="query">

 
  
required="yes">
 
  
required="yes">
 
  
required="yes">
 
  
type="array"
required="yes">
 
  

 
  
DATASOURCE="#Arguments.Dsn#">
 
    
TYPE="IN"
VALUE="#Arguments.AuthorizedUserId#" 
CFSQLTYPE="CF_SQL_CHAR">
 
    
VALUE="#Arguments.CountyCode#"
CFSQLTYPE="CF_SQL_CHAR">
 
    
VALUE="#Arguments.CaseFlag#"
CFSQLTYPE="CF_SQL_CHAR">
 
    
DBVARNAME="CourtOrderAvailableFlag"
TYPE="IN" 
VALUE="#Arguments.CourtOrderAvailableFlag#"
CFSQLTYPE="CF_SQL_CHAR">
 
    
 
  
 
  
    


  



-
Base.cfc
-


  and easy debugging utility when testin

RE: [flexcoders] Calling ArrayStructures in CFCs from Flex

2005-08-15 Thread dfatta 





Hi 
Malcolm,
 
Thanks 
for your advice.  Jeff's solutions worked well if you want to take a 
look.  I'm going to try to post my completed solution on some site.  

 
Darius

  -Original Message-From: flexcoders@yahoogroups.com 
  [mailto:[EMAIL PROTECTED]On Behalf Of MalcolmSent: 
  Wednesday, August 10, 2005 4:48 PMTo: 
  flexcoders@yahoogroups.comSubject: RE: [flexcoders] Calling 
  ArrayStructures in CFCs from FlexHi Darius,I 
  too went through the same pain (days & days of trying see what data 
  typesI could successfully return from a CFC).I'm still learning 
  but in my somewhat limited experience I could find no wayto return an 
  array datatype, it just wouldn't do it no matter what I tried,same goes 
  for structures. I have successfully returned the 
  followingdatatypes::String:Query:Boolean:Numeric 
  (yet to try):Date (yet to try)It's interesting to note that Flex 
  (somehow) in the background actuallyconverts a ColdFusion query to an 
  array. (Search the group on how these canbe accessed)At the moment 
  I am mostly using queries to get data back. This has theunfortunate side 
  effect of losing typing (everything in the query is astring), thus you may 
  need cast some results etc to their correct type 
  inFlex.Malcolm-Original Message-From: 
  flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] OnBehalf Of 
  coldfsSent: Friday, 5 August 2005 7:29 AMTo: 
  flexcoders@yahoogroups.comSubject: [flexcoders] Calling ArrayStructures in 
  CFCs from FlexHi,Using Tom Link's blog (http://tomlink.net/blog/index.cfm?mode=entry&entry=B662BEF9-7E97-A3B0-E3FB286E23BDAA50) 
  and other sources, I've been trying for days to translate queries to 
  arrays of structures (and vice versa).  Whatever I do, the cfc 
  doesn't except my values from Flex as arrays.  I know it's a chunk of 
  code to review, but you'd help a sane man going slowly 
  mad...:-)Many 
  thanks,Darius---index.mxml:---http://www.macromedia.com/2003/mxml">  
    
      
    
      
  endpoint="http://gx270dev.net/flashservices/gateway" 
  source="Model.mUtilities.mUpdate.qry_UpdateAuthorization" 
  fault="mx.controls.Alert.show(event.fault.faultstring)" 
  showBusyCursor="true">  
    result="doResult(event.result)"/>  
    
         
  wordWrap="true" 
  dataProvider="{RecordSetModel}">  
      
    
      
      
    
      
      
  width="200" headerText="Update Form" 
  columnName="Function"/>  
      
      
  width="320" headerText="Description" 
  columnName="Description"/>  
      
       
    
      
    
    
    
      
    
  --fx_UpdateAuthorization.cfc--  
    ("component","qry_UpdateAuthorization")>  
      
    returntype="array">  
    type="array" required="yes">  
    required="yes">  
    required="yes">  
    type="array" 
  required="yes">  
    required="yes">  
    (obj.GetUpdateAuthorization(AuthorizedUserIdObject,CountyCodeObject,CaseFlagObject,CourtOrderAvailableFlagObject,DsnObject))>  
    
  -qry_UpdateAuthorization.cfc-  
    returntype="query">  
    required="yes">  
    required="yes">  
    required="yes">  
    type="array" required="yes">  
      
    DATASOURCE="#Arguments.Dsn#">  
      TYPE="IN" 
  VALUE="#Arguments.AuthorizedUserId#" 
  CFSQLTYPE="CF_SQL_CHAR">  
      VALUE="#Arguments.CountyCode#" 
  CFSQLTYPE="CF_SQL_CHAR">  
      VALUE="#Arguments.CaseFlag#" 
  CFSQLTYPE="CF_SQL_CHAR">  
      DBVARNAME="CourtOrderAvailableFlag" TYPE="IN" 
  VALUE="#Arguments.CourtOrderAvailableFlag#" 
  CFSQLTYPE="CF_SQL_CHAR">  
        
    
    
         
    
  -Base.cfc-  
      
  required="yes">  
      
      
      
        
    
    
    addnewline="yes" 
  output="#varToOutput#">  
    
    
    
  /**  * Converts a query object into an array 
  of structures.  * 
    * @param query 
    The query to be transformed 
    * @return This function returns a 
  structure.   * @author Nathan Dintenfass 
  ([EMAIL PROTECTED])   * @version 1, 
  September 27, 2001   
  */  function 
  QueryToArrayOfStructures(theQuery){  
    var theArray = 
  arraynew(1);    
  var cols = ListtoArray(theQuery.columnlist);  
    var row = 1;  
    var thisRow = 
  "";    var col = 
  1;    for(row = 
  1; row LTE theQuery.recordcount; row = row + 
  1){    
    thisRow = 
  structnew();   

Re: [flexcoders] Calling ArrayStructures in CFCs from Flex

2005-08-12 Thread Jordan Snyder 


this works the best, returns a true array of objects to Flex.  Define
DataVO in a separate CFC.

On 8/12/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>  
> Thanks, Jeff.  That helps... 
>   
> I'm still stuck on how to handle the return recordset from the cfc.  If case
> sensitivity doesn't matter, how do you recommend dynamically getting all the
> data into the structure? 
>   
> 
> 
> 
> 
>  
>  
> 
>  
> -Original Message-
> From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED]
> Behalf Of Battershall, Jeff
> Sent: Friday, August 12, 2005 6:38 AM
> To: flexcoders@yahoogroups.com
> Subject: RE: [flexcoders] Calling ArrayStructures in CFCs from Flex
> 
>  
> Darius, 
>   
> What you want is an array of structures (what Flex wants), not a structure
> of arrays (what a CF Query is).  By using queryname.columnList, you get the
> keys you want to dynamically populate each structure, but unfortunately, 
> case sensitivity of column names isn't preserved - so you may end up hard
> coding each structure key if case sensitivity of your struct keys matters to
> your application. Also, your cfset var will have to be placed at the top of
> the function body, just after your CFARGUMENT tags. 
>   
> Jeff 
>  
>  
> -Original Message-
> From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On
> Behalf Of [EMAIL PROTECTED]
> Sent: Thursday, August 11, 2005 5:57 PM
> To: flexcoders@yahoogroups.com
> Subject: RE: [flexcoders] Calling ArrayStructures in CFCs from Flex
> 
>  
> Jeff, 
>   
> Great example! It almost works for me except the cfc I call from Flex is a
> facade to my cfc query.  The cfc query returns a variable that needs to be
> converted to an array or whatever before being put into a structure.  Do you
> have any ideas how to do this?  Many thanks, Darius 
>   
> 
>   
> 
>   returnType="Array">
>
>   
>   
>   
>   
>   
>"Model.mUtilities.mUpdate.qry_UpdateAuthorization">
>
> 
>returnvariable="qGetUpdateAuthorization">
>
>
>
> value="#CourtOrderAvailableFlag#">
>
>
>   
> 
>   
>   
>  
>   
>
> 
> 
> 
> 
>      
>  
>
>     
>   
>   
>
>   
>  
>  
>  
>   
>   
>  
>  
> -Original Message-
> From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On
> Behalf Of Battershall, Jeff
> Sent: Thursday, August 11, 2005 8:38 AM
> To: flexcoders@yahoogroups.com
> Subject: RE: [flexcoders] Calling ArrayStructures in CFCs from Flex
> 
> I'm jonny-come-lately to this thread, but I send and return arrays and
> structures to/from CFCs all the time.  I've abandoned passing back
> CFQueries as such but convert them to an array of structures first as
> that is what Flex UIComponents seem to like. 
> 
> Example code:
> 
>  access="public">
>   
> 
> 
> 
>  procedure="sp_GetIndustryCategories"
> datasource="#getDataSource()#">
>   
>   
>   
> 
>   
>   
>   
>  
> 
> 
> 
>   
> 
>   
> 
> If you were dealing with a dynamic list of columns the code could be
> altered as such:
> 
> 
> 
> 
> 
> 
>   
> 
> 
>  
>   
> 
> 
> 
> Produced in this fashion, Flex WILL accept this result as an array of
> structures. I'm mystified at the problem you're experiencing. 
> 
> Jeff
> 
> -Original Message-
> From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On
> Behalf Of Malcolm
> Sent: Wednesday, August 10, 2005 7:48 PM
> To: flexcoders@yahoogroups.com
> Subject: RE: [flexcoders] Calling ArrayStructures in CFCs from Flex
> 
> 
> Hi Darius,
> 
> I too went through the same pain (days & days of trying see what data
> types I could successfully return from a CFC).
> 
> I'm still learning but in my somewhat limited experience I could find no
> way to return an array datatype, it just wouldn't do it no matter what I
> tried, same goes for structures. I have successfully returned the
> following
> datatypes:
> 
&

RE: [flexcoders] Calling ArrayStructures in CFCs from Flex

2005-08-12 Thread dfatta 
Title: Message





Thanks, Jeff.  That helps...
 
I'm 
still stuck on how to handle the return recordset from the cfc.  If case 
sensitivity doesn't matter, how do you recommend dynamically getting all the 
data into the structure?
 
        
    
    
   
    
   

  -Original Message-From: flexcoders@yahoogroups.com 
  [mailto:[EMAIL PROTECTED]On Behalf Of Battershall, 
  JeffSent: Friday, August 12, 2005 6:38 AMTo: 
  flexcoders@yahoogroups.comSubject: RE: [flexcoders] Calling 
  ArrayStructures in CFCs from Flex
  Darius,
   
  What 
  you want is an array of structures (what Flex wants), not a structure of 
  arrays (what a CF Query is).  By using queryname.columnList, you get the 
  keys you want to dynamically populate each structure, but unfortunately,  
  case sensitivity of column names isn't preserved - so you may end up hard 
  coding each structure key if case sensitivity of your struct keys matters to 
  your application. Also, your cfset var will have to be placed at the top of 
  the function body, just after your CFARGUMENT tags. 
   
  Jeff
  

-Original Message-From: 
flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf 
Of [EMAIL PROTECTED]Sent: Thursday, August 11, 2005 5:57 
PMTo: flexcoders@yahoogroups.comSubject: RE: 
    [flexcoders] Calling ArrayStructures in CFCs from Flex
Jeff,
 
Great example! It almost works for me except the cfc I call from Flex 
is a facade to my cfc query.  The cfc query returns a variable that 
needs to be converted to an array or whatever before being put into a 
structure.  Do you have any ideas how to do this?  Many thanks, 
Darius
 
 
      
   
 
    
  
        
    
    
   
    
   
    
    
  

 
  
 
  
 
 

  
  -Original Message-From: 
  flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On 
  Behalf Of Battershall, JeffSent: Thursday, August 11, 2005 
  8:38 AMTo: flexcoders@yahoogroups.comSubject: RE: 
  [flexcoders] Calling ArrayStructures in CFCs from 
  FlexI'm jonny-come-lately to this thread, but I 
  send and return arrays andstructures to/from CFCs all the time.  
  I've abandoned passing backCFQueries as such but convert them to an 
  array of structures first asthat is what Flex UIComponents seem to 
  like. Example code:access="public">  
      
    
      
      
      
    datasource="#getDataSource()#">  
      
    
    
    
      
      
        
        
        
        
      
    
    
      
      
    If you 
  were dealing with a dynamic list of columns the code could bealtered 
  as such:  
      
      
        
    
    
      
    Produced 
  in this fashion, Flex WILL accept this result as an array 
  ofstructures. I'm mystified at the problem you're experiencing. 
  Jeff-Original Message-From: 
  flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] 
  OnBehalf Of MalcolmSent: Wednesday, August 10, 2005 7:48 PMTo: 
  flexcoders@yahoogroups.comSubject: RE: [flexcoders] Calling 
  ArrayStructures in CFCs from FlexHi Darius,I too went 
  through the same pain (days & days of trying see what datatypes I 
  could successfully return from a CFC).I'm still learning but in my 
  somewhat limited experience I could find noway to return an array 
  datatype, it just wouldn't do it no matter what Itried, same goes for 
  structures. I have successfully returned 
  thefollowingdatatypes::String:Query:Boolean:Numeric 
  (yet to try):Date (yet to try)It's interesting to note that 
  Flex (somehow) in the background actuallyconverts a ColdFusion query 
  to an array. (Search the group on how thesecan be accessed)At 
  the moment I am mostly using queries to get data back. This has 
  theunfortunate side effect of losing typing (everything in the query 
  is astring), thus you may need cast some results etc to their correct 
  typein Flex.Malcolm-Original Message-From: 
  flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] 
  OnBehalf Of coldfsSent: Friday, 5 August 2005 7:29 AMTo: 
  flexcoders@yahoogroups.comSubject: [flexcoders] Calling 
  ArrayStructures in CFCs from FlexHi,Using Tom Link's blog 
  (http://tomlin

RE: [flexcoders] Calling ArrayStructures in CFCs from Flex

2005-08-12 Thread Battershall, Jeff 
Title: Message





Darius,
 
What 
you want is an array of structures (what Flex wants), not a structure of arrays 
(what a CF Query is).  By using queryname.columnList, you get the keys you 
want to dynamically populate each structure, but unfortunately,  case 
sensitivity of column names isn't preserved - so you may end up hard coding 
each structure key if case sensitivity of your struct keys matters to your 
application. Also, your cfset var will have to be placed at the top of the 
function body, just after your CFARGUMENT tags. 
 
Jeff

  
  -Original Message-From: 
  flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of 
  [EMAIL PROTECTED]Sent: Thursday, August 11, 2005 5:57 
  PMTo: flexcoders@yahoogroups.comSubject: RE: 
  [flexcoders] Calling ArrayStructures in CFCs from Flex
  Jeff,
   
  Great example! It almost works for me except the cfc I call from Flex 
  is a facade to my cfc query.  The cfc query returns a variable that needs 
  to be converted to an array or whatever before being put into a 
  structure.  Do you have any ideas how to do this?  Many thanks, 
  Darius
   
   
        
     
   
        
          
      
      
     
      
     
      
      
    
   
    
   
    
   
   
  

-Original Message-From: 
flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf 
Of Battershall, JeffSent: Thursday, August 11, 2005 8:38 
AMTo: flexcoders@yahoogroups.comSubject: RE: 
[flexcoders] Calling ArrayStructures in CFCs from 
FlexI'm jonny-come-lately to this thread, but I 
send and return arrays andstructures to/from CFCs all the time.  
I've abandoned passing backCFQueries as such but convert them to an 
array of structures first asthat is what Flex UIComponents seem to like. 
Example code:access="public">  
      
    
    
    
  datasource="#getDataSource()#">  
    
  
  
  
    
    
      
      
      
      
    
  
  
    
    
  If you 
were dealing with a dynamic list of columns the code could bealtered as 
such:  
    
    
      
  
  
    
  Produced in 
this fashion, Flex WILL accept this result as an array ofstructures. I'm 
mystified at the problem you're experiencing. 
Jeff-Original Message-From: 
flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] OnBehalf 
Of MalcolmSent: Wednesday, August 10, 2005 7:48 PMTo: 
flexcoders@yahoogroups.comSubject: RE: [flexcoders] Calling 
ArrayStructures in CFCs from FlexHi Darius,I too went 
through the same pain (days & days of trying see what datatypes I 
could successfully return from a CFC).I'm still learning but in my 
somewhat limited experience I could find noway to return an array 
datatype, it just wouldn't do it no matter what Itried, same goes for 
structures. I have successfully returned 
thefollowingdatatypes::String:Query:Boolean:Numeric 
(yet to try):Date (yet to try)It's interesting to note that Flex 
(somehow) in the background actuallyconverts a ColdFusion query to an 
array. (Search the group on how thesecan be accessed)At the 
moment I am mostly using queries to get data back. This has 
theunfortunate side effect of losing typing (everything in the query is 
astring), thus you may need cast some results etc to their correct 
typein Flex.Malcolm-Original Message-From: 
flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] OnBehalf 
Of coldfsSent: Friday, 5 August 2005 7:29 AMTo: 
flexcoders@yahoogroups.comSubject: [flexcoders] Calling ArrayStructures 
in CFCs from FlexHi,Using Tom Link's blog (http://tomlink.net/blog/index.cfm?mode=entry&entry=B662BEF9-7E97-A3B0-E3FB286E23BDAA50) 
and other sources, I've been trying for days to translate queries to 
arrays of structures (and vice versa).  Whatever I do, the cfc 
doesn't except my values from Flex as arrays.  I know it's a chunk 
of code to review, but you'd help a sane man going slowly 
mad...:-)Many 
thanks,Darius---index.mxml:---http://www.macromedia.com/2003/mxml">  
  
  
  
  
    
endpoint="http://gx270dev.net/flashservices/gateway" 
source="Model.mUtilities.mUpdate.qry_UpdateAuthorization" 
fault="mx.controls.Alert.show(event.fault.faultstring)" 
showBusyCursor="true&q

RE: [flexcoders] Calling ArrayStructures in CFCs from Flex

2005-08-11 Thread dfatta 
Title: Message





Jeff,
 
Great 
example! It almost works for me except the cfc I call from Flex is a facade to 
my cfc query.  The cfc query returns a variable that needs to be converted 
to an array or whatever before being put into a structure.  Do you have any 
ideas how to do this?  Many thanks, Darius
 
 
      
   
 
      
        
    
    
   
    
   
    
    
  
 
  
 
  
 
 

  
  -Original Message-From: 
  flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of 
  Battershall, JeffSent: Thursday, August 11, 2005 8:38 
  AMTo: flexcoders@yahoogroups.comSubject: RE: 
  [flexcoders] Calling ArrayStructures in CFCs from 
  FlexI'm jonny-come-lately to this thread, but I send 
  and return arrays andstructures to/from CFCs all the time.  I've 
  abandoned passing backCFQueries as such but convert them to an array of 
  structures first asthat is what Flex UIComponents seem to like. 
  Example code:access="public">  
        
        
      
      
  datasource="#getDataSource()#">  
        
    
    
      
      
        
        
        
        
      
    
    
      
      
    If you were 
  dealing with a dynamic list of columns the code could bealtered as 
  such:  
      
        
      
    
    
      
    Produced in 
  this fashion, Flex WILL accept this result as an array ofstructures. I'm 
  mystified at the problem you're experiencing. 
  Jeff-Original Message-From: 
  flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] OnBehalf Of 
  MalcolmSent: Wednesday, August 10, 2005 7:48 PMTo: 
  flexcoders@yahoogroups.comSubject: RE: [flexcoders] Calling 
  ArrayStructures in CFCs from FlexHi Darius,I too went 
  through the same pain (days & days of trying see what datatypes I 
  could successfully return from a CFC).I'm still learning but in my 
  somewhat limited experience I could find noway to return an array 
  datatype, it just wouldn't do it no matter what Itried, same goes for 
  structures. I have successfully returned 
  thefollowingdatatypes::String:Query:Boolean:Numeric 
  (yet to try):Date (yet to try)It's interesting to note that Flex 
  (somehow) in the background actuallyconverts a ColdFusion query to an 
  array. (Search the group on how thesecan be accessed)At the moment 
  I am mostly using queries to get data back. This has theunfortunate side 
  effect of losing typing (everything in the query is astring), thus you may 
  need cast some results etc to their correct typein 
  Flex.Malcolm-Original Message-From: 
  flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] OnBehalf Of 
  coldfsSent: Friday, 5 August 2005 7:29 AMTo: 
  flexcoders@yahoogroups.comSubject: [flexcoders] Calling ArrayStructures in 
  CFCs from FlexHi,Using Tom Link's blog (http://tomlink.net/blog/index.cfm?mode=entry&entry=B662BEF9-7E97-A3B0-E3FB286E23BDAA50) 
  and other sources, I've been trying for days to translate queries to 
  arrays of structures (and vice versa).  Whatever I do, the cfc 
  doesn't except my values from Flex as arrays.  I know it's a chunk of 
  code to review, but you'd help a sane man going slowly 
  mad...:-)Many 
  thanks,Darius---index.mxml:---http://www.macromedia.com/2003/mxml">  
    
      
    
      
  endpoint="http://gx270dev.net/flashservices/gateway" 
  source="Model.mUtilities.mUpdate.qry_UpdateAuthorization" 
  fault="mx.controls.Alert.show(event.fault.faultstring)" 
  showBusyCursor="true">  
    result="doResult(event.result)"/>  
    
         
  wordWrap="true" 
  dataProvider="{RecordSetModel}">  
      
    
      
      
    
      
      
  width="200" headerText="Update Form" 
  columnName="Function"/>  
      
      
  width="320" headerText="Description" 
  columnName="Description"/>  
      
       
    
      
    
    
    
      
    
  --fx_UpdateAuthorization.cfc--  
    ("component","qry_UpdateAuthorization")>  
      
    returntype="array">  
    type="array" required="yes">  
    required="yes">  
    required="yes">  
    type="array" 
  required="yes">  
    required="yes">  
    (obj.GetUpdateAuthorization(AuthorizedUserIdObject,CountyCodeObject,CaseFlagObject,CourtOrderAvailableFlagObject,DsnObject))>  
    
  -qry_UpdateAuthorization.cfc-  
    returntype="query">  
    required="yes"> 

RE: [flexcoders] Calling ArrayStructures in CFCs from Flex

2005-08-11 Thread Battershall, Jeff 
I'm jonny-come-lately to this thread, but I send and return arrays and
structures to/from CFCs all the time.  I've abandoned passing back
CFQueries as such but convert them to an array of structures first as
that is what Flex UIComponents seem to like. 

Example code:




   



 





  


   

   

If you were dealing with a dynamic list of columns the code could be
altered as such:









  



Produced in this fashion, Flex WILL accept this result as an array of
structures. I'm mystified at the problem you're experiencing. 

Jeff

-Original Message-
From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Malcolm
Sent: Wednesday, August 10, 2005 7:48 PM
To: flexcoders@yahoogroups.com
Subject: RE: [flexcoders] Calling ArrayStructures in CFCs from Flex


Hi Darius,

I too went through the same pain (days & days of trying see what data
types I could successfully return from a CFC).

I'm still learning but in my somewhat limited experience I could find no
way to return an array datatype, it just wouldn't do it no matter what I
tried, same goes for structures. I have successfully returned the
following
datatypes:

:String
:Query
:Boolean

:Numeric (yet to try)
:Date (yet to try)

It's interesting to note that Flex (somehow) in the background actually
converts a ColdFusion query to an array. (Search the group on how these
can be accessed)

At the moment I am mostly using queries to get data back. This has the
unfortunate side effect of losing typing (everything in the query is a
string), thus you may need cast some results etc to their correct type
in Flex.

Malcolm

-Original Message-
From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of coldfs
Sent: Friday, 5 August 2005 7:29 AM
To: flexcoders@yahoogroups.com
Subject: [flexcoders] Calling ArrayStructures in CFCs from Flex

Hi,

Using Tom Link's blog (http://tomlink.net/blog/index.cfm?
mode=entry&entry=B662BEF9-7E97-A3B0-E3FB286E23BDAA50) and other 
sources, I've been trying for days to translate queries to arrays of 
structures (and vice versa).  Whatever I do, the cfc doesn't except 
my values from Flex as arrays.  I know it's a chunk of code to 
review, but you'd help a sane man going slowly mad...:-)

Many thanks,
Darius

---
index.mxml:
---

http://www.macromedia.com/2003/mxml";>






http://gx270dev.net/flashservices/gateway"; 
source="Model.mUtilities.mUpdate.qry_UpdateAuthorization" 
fault="mx.controls.Alert.show(event.fault.faultstring)" 
showBusyCursor="true">




   
 
  


   
 






--
fx_UpdateAuthorization.cfc
--

















-
qry_UpdateAuthorization.cfc
-


















   





-
Base.cfc
-













/**
 * Converts a query object into an array of structures.
 * 
 * @param query  The query to be transformed 
 * @return This function returns a structure. 
 * @author Nathan Dintenfass ([EMAIL PROTECTED]) 
 * @version 1, September 27, 2001 
 */
function QueryToArrayOfStructures(theQuery){
var theArray = arraynew(1);
var cols = ListtoArray(theQuery.columnlist);
var row = 1;
var thisRow = "";
var col = 1;
for(row = 1; row LTE theQuery.recordcount; row = row 
+ 1){
thisRow = structnew();
f

RE: [flexcoders] Calling ArrayStructures in CFCs from Flex

2005-08-10 Thread Malcolm 
Hi Darius,

I too went through the same pain (days & days of trying see what data types
I could successfully return from a CFC).

I'm still learning but in my somewhat limited experience I could find no way
to return an array datatype, it just wouldn't do it no matter what I tried,
same goes for structures. I have successfully returned the following
datatypes:

:String
:Query
:Boolean

:Numeric (yet to try)
:Date (yet to try)

It's interesting to note that Flex (somehow) in the background actually
converts a ColdFusion query to an array. (Search the group on how these can
be accessed)

At the moment I am mostly using queries to get data back. This has the
unfortunate side effect of losing typing (everything in the query is a
string), thus you may need cast some results etc to their correct type in
Flex.

Malcolm

-Original Message-
From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of coldfs
Sent: Friday, 5 August 2005 7:29 AM
To: flexcoders@yahoogroups.com
Subject: [flexcoders] Calling ArrayStructures in CFCs from Flex

Hi,

Using Tom Link's blog (http://tomlink.net/blog/index.cfm?
mode=entry&entry=B662BEF9-7E97-A3B0-E3FB286E23BDAA50) and other 
sources, I've been trying for days to translate queries to arrays of 
structures (and vice versa).  Whatever I do, the cfc doesn't except 
my values from Flex as arrays.  I know it's a chunk of code to 
review, but you'd help a sane man going slowly mad...:-)

Many thanks,
Darius

---
index.mxml:
---

http://www.macromedia.com/2003/mxml";>






http://gx270dev.net/flashservices/gateway"; 
source="Model.mUtilities.mUpdate.qry_UpdateAuthorization" 
fault="mx.controls.Alert.show(event.fault.faultstring)" 
showBusyCursor="true">




   
 
  


   
 






--
fx_UpdateAuthorization.cfc
--

















-
qry_UpdateAuthorization.cfc
-


















   





-
Base.cfc
-













/**
 * Converts a query object into an array of structures.
 * 
 * @param query  The query to be transformed 
 * @return This function returns a structure. 
 * @author Nathan Dintenfass ([EMAIL PROTECTED]) 
 * @version 1, September 27, 2001 
 */
function QueryToArrayOfStructures(theQuery){
var theArray = arraynew(1);
var cols = ListtoArray(theQuery.columnlist);
var row = 1;
var thisRow = "";
var col = 1;
for(row = 1; row LTE theQuery.recordcount; row = row 
+ 1){
thisRow = structnew();
for(col = 1; col LTE arraylen(cols); col = 
col + 1){
thisRow[cols[col]] = theQuery[cols
[col]][row];
}
arrayAppend(theArray,duplicate(thisRow));
}
return(theArray);
}

/**
 * Converts an array of structures to a CF Query Object.
 * 6-19-02: Minor revision by Rob Brooks-Bilson 
([EMAIL PROTECTED])
 * 
 * Update to handle empty array passed in. Mod by Nathan 
Dintenfass. Also no longer using list func.
 * 
 * @param Array  The array of structures to be 
converted to a query object.  Assumes each array element contains 
structure with same  (Required)
 * @return Returns a query object. 
 * @author David Crawford ([EMAIL PROTECTED]) 
 * @version 2, March 19, 2003 
 */
function arrayOfStructuresToQuery(theArray){
var colNames = "";
var theQuery = queryNew("");
var i=0;
var j=0;
//if there's nothing in the array, return the empty 
query
if(NOT arrayLen(th

[flexcoders] Calling ArrayStructures in CFCs from Flex

2005-08-04 Thread coldfs 
Hi,

Using Tom Link's blog (http://tomlink.net/blog/index.cfm?
mode=entry&entry=B662BEF9-7E97-A3B0-E3FB286E23BDAA50) and other 
sources, I've been trying for days to translate queries to arrays of 
structures (and vice versa).  Whatever I do, the cfc doesn't except 
my values from Flex as arrays.  I know it's a chunk of code to 
review, but you'd help a sane man going slowly mad...:-)

Many thanks,
Darius

---
index.mxml:
---

http://www.macromedia.com/2003/mxml";>






http://gx270dev.net/flashservices/gateway"; 
source="Model.mUtilities.mUpdate.qry_UpdateAuthorization" 
fault="mx.controls.Alert.show(event.fault.faultstring)" 
showBusyCursor="true">




   
 
  


   
 






--
fx_UpdateAuthorization.cfc
--

















-
qry_UpdateAuthorization.cfc
-


















   





-
Base.cfc
-













/**
 * Converts a query object into an array of structures.
 * 
 * @param query  The query to be transformed 
 * @return This function returns a structure. 
 * @author Nathan Dintenfass ([EMAIL PROTECTED]) 
 * @version 1, September 27, 2001 
 */
function QueryToArrayOfStructures(theQuery){
var theArray = arraynew(1);
var cols = ListtoArray(theQuery.columnlist);
var row = 1;
var thisRow = "";
var col = 1;
for(row = 1; row LTE theQuery.recordcount; row = row 
+ 1){
thisRow = structnew();
for(col = 1; col LTE arraylen(cols); col = 
col + 1){
thisRow[cols[col]] = theQuery[cols
[col]][row];
}
arrayAppend(theArray,duplicate(thisRow));
}
return(theArray);
}

/**
 * Converts an array of structures to a CF Query Object.
 * 6-19-02: Minor revision by Rob Brooks-Bilson 
([EMAIL PROTECTED])
 * 
 * Update to handle empty array passed in. Mod by Nathan 
Dintenfass. Also no longer using list func.
 * 
 * @param Array  The array of structures to be 
converted to a query object.  Assumes each array element contains 
structure with same  (Required)
 * @return Returns a query object. 
 * @author David Crawford ([EMAIL PROTECTED]) 
 * @version 2, March 19, 2003 
 */
function arrayOfStructuresToQuery(theArray){
var colNames = "";
var theQuery = queryNew("");
var i=0;
var j=0;
//if there's nothing in the array, return the empty 
query
if(NOT arrayLen(theArray))
return theQuery;
//get the column names into an array =
colNames = structKeyArray(theArray[1]);
//build the query based on the colNames
theQuery = queryNew(arrayToList(colNames));
//add the right number of rows to the query
queryAddRow(theQuery, arrayLen(theArray));
//for each element in the array, loop through the 
columns, populating the query
for(i=1; i LTE arrayLen(theArray); i=i+1){
for(j=1; j LTE arrayLen(colNames); j=j+1){
querySetCell(theQuery, colNames[j], 
theArray[i][colNames[j]], i);
}
}
return theQuery;
}










 Yahoo! Groups Sponsor ~--> 
http://us.ard.yahoo.com/SIG=12hkr7jf0/M=362335.6886445.7839731.1510227/D=groups/S=1705007207:TM/Y=YAHOO/EXP=1123204006/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In
 low income neighborhoods, 84% do not