You are getting an error somewhere else...open up coursecatalog.cfm and step through it... something is happening before this query.
-Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Phillip Vector [mailto:[email protected]] Sent: Thursday, May 19, 2011 8:29 AM To: cf-talk Subject: Re: Recordcount not working???? >Can we see more of the code? There's obviously something funny here >and we're not able to see it. <cfif (not isdefined("session.stack")) or (not isdefined("session.stackT")) or (not listlen(session.stack) is listlen(session.stackT)) or (listlen(session.stack) gt 40) > <cflock scope="SESSION" timeout="2"><cfset session.stack=""> <cfset session.stackt=""> </cflock> </cfif> <cfset me="CourseCatalog.cfm"> <cfquery name="OpenedUpSeats" dbtype="ODBC" datasource="TrainingBE"> Select * from OpenedUpSeatsView </cfquery> <cfdump var="#OpenedUpSeats#" abort> That's the code there. I get at the end "Variable OPENEDUPSEATS is undefined.". Even when I removed the where, it's still messing up. The view exists. The datasource is correct. I just don't get it. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:344701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
