Phillip..I don't think dbtype is supported for anything other than type: query any more. On May 19, 2011 9:34 AM, "Phillip Vector" <vec...@mostdeadlygame.com> wrote: > >>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:344685 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm