This sort of makes sense. The DB rejected the request, somewhere in the process the JDBC driver returned "nothing" or NULL or something not exactly expected and closed the request. CF not getting a result set (not even an empty results set) didn't set the query result set variable. Thus you get an error trying to reference the query.
I've seen similar issues like this in the past where the JDBC didn't give CF a response or maybe it was a null response and closed the request. CF continues as if nothing happened and the query variable is never set. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com [email protected] www.trunkful.com On May 19, 2011, at 10:45 AM, Phillip Vector wrote: > >> Thanks.. I will check with our DB admin and see. > > Turns out, I didn't have permission for the view. I since got it and he > mentioned that the view has no records at all anyway and to just put in a > <cfset > OpenedUpSeats.recordcount = 0> to move past it. > > So yeah. Still a mystery, but we are moving past and not worrying about it. > Thanks for the help people and if you guys can think of anything else, please > let me know as I hate having the code that kludgy. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:344699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
