Re: Using CFloop to pull data from CFC

2009-01-25 Thread Patrick McDonough
thanks I have got past this. 

Pat /grfxs 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318492
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Using CFloop to pull data from CFC

2009-01-25 Thread Joel Watson
That is, "returnvariable=result", and then loop over "result".

> You need to return and loop over "result" (what is being returned from 
> your component), not the method name.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318489
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Using CFloop to pull data from CFC

2009-01-25 Thread Joel Watson
You need to return and loop over "result" (what is being returned from your 
component), not the method name.

> I am having trouble pulling data from a cfc for a pull down menu. Here 
> is the code from the cfm file:
> 

> 

> 

> 

>   class="navbar">Catalog Request

>  Our Products 

> 
   
>  returnvariable="getCategories"/>
  
> 
  
> 
   
> 
   
> 

> 

>#Title# 
> 

> 
   
> 
   
> 

> 
  
> 
  
>   class="navbar">Track a Shipment
 
> 
  
> Customer Service

> 
  
> Industry 
> Links
  
>  Terms & 
> Conditions
  
>class="navbar">Warranty
  
> About Us

> 

> 

> 
  
> 
  
>   class="navbar">Find a Reseller

> 
  
> 
> 
> 
> The CFC has the method "getCategories" and is set up like this:
> 
> 
> 
> 
   
> 

> 
 
> 
  
> 
  
> 
  
> 
  
> 
 
> 
   
> 

> SELECT ID, Title, URLalias

> FROM categories

> WHERE memberOf=0

> AND active=1

>
   
> 

> 
  
> 
 
> 
 
> 
 
> 
> 
  
> 

> 
  
> 
   
> 
  
> 
   
> 
   
> 
  
> 
> 
  
> 

> 
  
> 
  
> 
  
> 
> 
  
> 

> 
   
> 

> SELECT Title, URLalias, ID

> FROM categories

> WHERE memberOF=#ARGUMENTS.ID#

> AND active=1

> AND deleted=0
  
> 
  
> 
  
> 
  
> 
 
> 
 
> 
 
> 
  
> 
> 
  
> 
  
> 
   
> 
 
> 
   
> 
> 
> 
> 
> How do I set up the CFloop to pull the data from the CFC? 
> 
> Help is appreciated!
> 
> 
> 
> PAtrick
> patgrfxs (AIM and Yahoo)


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318488
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4