What happens when you dump OpenedUpSeats and/or isquery(OpenedUpSeats) ? On Thu, May 19, 2011 at 6:57 AM, Phillip Vector <vec...@mostdeadlygame.com>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#"> > > and same error. > > Any ideas? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:344647 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm