You probably saw it by now, but in the second one, your query is named "allInv" but you return "invAll"
On 8/26/02 12:07 PM, "Stephenie Hamilton" <[EMAIL PROTECTED]> wrote: > I am playing around with some cfc's to get a better grasp of them on > MX... > > Now, one of the methods works fine (category)...one does not (getAll)... > Here is the cfc code (inventory.cfc) > --------------------- > <cfcomponent hint="Inventory functionality"> > > <!--- list all categories ---> > <cffunction name="Category" hint="Get list of categories"> > > <cfquery name="getCat" datasource="coldfusionwebscom"> > SELECT * > FROM Category > </cfquery> > > <cfreturn getCat> > </cffunction> > > <!--- get all in inventory table ---> > <cffunction name="getAll" access="remote"> > > <Cfquery name="allInv" datasource="coldfusionwebscom"> > SELECT * > FROM Inventory > </CFQUERY> > > > <cfreturn invAll> > > </cffunction> > </cfcomponent> > > -------------------------------------------------- > > Here are the calls to the methods > -------------------------------------------- > Get the cateogries (category):<br><br><br> > > <cfinvoke component="Inventory" method="Category" returnvariable="cat"> > <cfdump var= #cat#> > > > get all inventory (getall):<br> > <br><br> > <cfinvoke component="Inventory" method="getAll" > returnvariable="InvResult"> <cfdump var= #InvResult#> > > > --------------------------------------------- > > The category method works fine, shows me all the categories... The > getAll does not. It says Error Occurred While Processing Request > Variable INVALL is undefined. > > > You can see this here: > > http://coldfusionwebs.com/mxtest/inventory.cfm > > What is up with this? They are called the same exact way...the query > allINV is returning 212 records..... Any ideas? > > ~~ > Stephenie > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists