<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:344646
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
