No worries Charlie: Ironically when I wrote #products.description1# the products was the table name not the query name. If I had gotten it right it would have been a coinsidence. Now I KNOW how it works. and makes total sence. Thanks for bearing with me.
Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com <http://www.motorcyclecarbs.com/> _____ From: Charlie Arehart [mailto:[EMAIL PROTECTED] Sent: Sunday, March 11, 2007 9:14 PM To: Carbs Sales&Service Subject: RE: [ACFUG Discuss] Variable Undefined. Robert, this was what I meant when I first wrote: ... if the query returns multiple records, why are you not making the CFOUTPUT a query loop? And if it returns only one, then even if you don't choose to use a loop, you will need to name prefix the columns when you refer to them after the query. So while you can indeed use a CFOUTPUT QUERY loop, as Ajas points out, you had sais: I have tried #products.description1# also but that does not work either. You were close. That was just a typo.You should have used product rather than products. Just clarifying for future reference. /Charlie http://www.carehart.org/ <http://www.carehart.org/> _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil Sent: Sunday, March 11, 2007 8:46 AM To: [email protected] Subject: RE: [ACFUG Discuss] Variable Undefined. THATS IT!!!!! Thanks so much!!!! -->to infinity.!!!!!!!!! Now I can move forward. Thank again to all on this list who have helped in all my stumbles. Robert P. Reil _____ From: Ajas Mohammed [mailto:[EMAIL PROTECTED] Sent: Sunday, March 11, 2007 8:39 AM To: Carbs Sales&Service Subject: Re: [ACFUG Discuss] Variable Undefined. You got that error because when you write <cfoutput>, you are not providing the query name whose OUTPUT you want to display. The correct method is <cfoutput query="product">. Replace your cfoutput with this and see what happens. Ajas Mohammed. ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform <http://www.acfug.org?fa=login.edituserform> For more info, see http://www.acfug.org/mailinglists <http://www.acfug.org/mailinglists> Archive @ http://www.mail-archive.com/discussion%40acfug.org/ <http://www.mail-archive.com/discussion%40acfug.org/> List hosted by FusionLink <http://www.fusionlink.com> -------------------------------------------------------------
<<attachment: att9ebf6.jpg>>
