>On 5/19/2011 7:57 AM, Phillip Vector wrote: > >Run it without the Where clause in the SQL and see what happens.
<cfquery name="OpenedUpSeats" dbtype="ODBC" datasource="TrainingBE"> Select * from OpenedUpSeatsView </cfquery> <cfdump var="#OpenedUpSeats#" abort> gets me Variable OPENEDUPSEATS is undefined. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:344654 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

