Roger, What happens when you just do
<cfdump var="#OpenedUpSeats#"/> (and what in the ham sandwich is this use of writeoutput()) Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Roger Austin [mailto:raust...@nc.rr.com] Sent: Thursday, May 19, 2011 7:26 AM To: cf-talk Subject: Re: Recordcount not working???? On 5/19/2011 7:57 AM, Phillip Vector wrote: > > <cfquery name="OpenedUpSeats" dbtype="ODBC" datasource="TrainingBE"> > Select * > from OpenedUpSeatsView > where account='<cfset zz=writeoutput(session.account)>' > </cfquery> > > <cfif OpenedUpSeats.RecordCount> > > First of all.. This isn't my code, so I know it's pretty bad. The Query doesn't error, but when it hits the recordcount, I get the "Element RECORDCOUNT is undefined in OPENEDUPSEATS." > > Huh? Isn't recordcount ALWAYS a part of the query? Any ideas how to fix this? > > For the record, I've also tried this.. > > <cfquery name="OpenedUpSeats" datasource="TrainingBE"> > Select * > from OpenedUpSeatsView > where account='#session.account#' > </cfquery> > > <cfdump var="#OpenedUpSeats.RecordCount#"> Run it without the Where clause in the SQL and see what happens. -- LinkedIn: http://www.linkedin.com/pub/8/a4/60 Twitter: http://twitter.com/RogerTheGeek Blog: http://rogerthegeek.wordpress.com/ MissHunt: http://www.misshunt.com/ (Home of the Clean/Dirty Magnet) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344653 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm