RE: Cfc's and undefined variable - why does one work, but not the other
Yeahsometimes I am dyslexic I guess ~~ Stephenie > |-Original Message- > |From: Jann VanOver [mailto:[EMAIL PROTECTED]] > |Sent: Monday, August 26, 2002 3:45 PM > |To: CF-Talk > |Subject: Re: Cfc's and undefined variable - why does one > |work, but not the other > | > | > |You probably saw it by now, but in the second one, your > |query is named "allInv" but you return "invAll" > | __ Get the mailserver that powers this list at http://www.coolfusion.com 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
Re: Cfc's and undefined variable - why does one work, but not the other
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) > - > > > > > > > SELECT * > FROM Category > > > > > > > > > > SELECT * > FROM Inventory > > > > > > > > > -- > > Here are the calls to the methods > > Get the cateogries (category): > > > > > > get all inventory (getall): > > returnvariable="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
Re: Cfc's and undefined variable - why does one work, but not the other
It's not a CFC issue actually... You're returning "invAll", but the name of your variable ( query ) is "allInv" ... :) Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 > 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) > - > > > > > SELECT * > FROM Category > > > > > > > SELECT * > FROM Inventory > > > > > -- > Here are the calls to the methods > > Get the cateogries (category): > > > get all inventory (getall): > > returnvariable="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 > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
RE: Cfc's and undefined variable - why does one work, but not the other
Doh ** smacks self on head ** Thanks! ~~ Stephenie > |-Original Message- > |From: Collin Tobin [mailto:[EMAIL PROTECTED]] > |Sent: Monday, August 26, 2002 3:16 PM > |To: CF-Talk > |Subject: RE: Cfc's and undefined variable - why does one > |work, but not the other > | > | > |Looks like you've reversed your query name in your cfresult... > | > | > |Collin Tobin > |QA Engineer > | > |macromedia.com > |617 219 2000 > |[EMAIL PROTECTED] > | > | > __ Get the mailserver that powers this list at http://www.coolfusion.com 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
RE: Cfc's and undefined variable - why does one work, but not the other
Try adding the returnType attribute to the getAll function as given below: SELECT * FROM Inventory HTH Kumaran -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 3:07 PM To: CF-Talk Subject: Cfc's and undefined variable - why does one work, but not the other 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) - SELECT * FROM Category SELECT * FROM Inventory -- Here are the calls to the methods Get the cateogries (category): get all inventory (getall): - 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 __ Get the mailserver that powers this list at http://www.coolfusion.com 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
RE: Cfc's and undefined variable - why does one work, but not the other
Looks like you've reversed your query name in your cfresult... Collin Tobin QA Engineer macromedia.com 617 219 2000 [EMAIL PROTECTED] -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 3:07 PM To: CF-Talk Subject: Cfc's and undefined variable - why does one work, but not the other 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) - SELECT * FROM Category SELECT * FROM Inventory -- Here are the calls to the methods Get the cateogries (category): get all inventory (getall): - 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 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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