Hello, I have migrating from CF7 to CF9, and have found a strange problem. It seems when I try to reference a query that has no results, CF thinks that object does not exist but this behavior is not consistent.
I have full debugging turned on for my local machine, and I can even see the query listed in the SQL Queries section. I cannot figure out for the life of me why certain queries, when empty, cannot be referenced for properties like RecordCount. As a temporary workaround I am using IsDefined to see if the object exists instead of .RecordCount to see if it is populated. I have verified that if the query does return data that is works as normal. and it does. Has anyone encountered this behavior, or have any idea why this is occurring? Thanks, Brian Cain ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:352270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
