Did you apply the 9.0.1 update after upgrading? It sounds very similar to an issue that was fixed in that update.
Debbie -----Original Message----- From: Brian Cain [mailto:[email protected]] Sent: Wednesday, August 22, 2012 5:51 PM To: cf-talk Subject: Re: Query with no results is not defined It is not in a CFC <CFQUERY name="PastDueInvoices" datasource="#appdatasource#"> SELECT r.ID, r.InvoiceDate, r.DueByDate, r.DatePaid, r.Approved, Sum(li.Quantity*li.Cost) - Sum(li.Quantity*li.Discount) as AmountDue FROM Receipts r LEFT JOIN LineItems li ON li.ReceiptID = r.ID WHERE r.SubscriberID = #session.stUser.ID# AND r.Approved = 1 AND r.DatePaid is null AND IsNull(r.HideMyAccount, 0) <> 1 GROUP By r.ID, r.InvoiceDate, r.DueByDate, r.DatePaid, r.Approved HAVING Sum(li.Quantity*li.Cost) - Sum(li.Quantity*li.Discount) > 0 ORDER BY r.Approved DESC, r.InvoiceDate DESC </CFQUERY> <cfif IsDefined("PastDueInvoices")> <CFIF PastDueInvoices.RecordCount GT 0> IT ERRORS RIGHT HERE! This is copied and pasted directly form the cfm page. The condition to look and the record count attribute was literally the next line of code before I added the IsDefined check. On Wed, Aug 22, 2012 at 4:46 PM, Cameron Childress <[email protected]>wrote: > > On Wed, Aug 22, 2012 at 5:38 PM, Brian Cain <[email protected]> wrote: > > > Has anyone encountered this behavior, or have any idea why this is > > occurring? > > > Is it in a CFC? Smells like an improperly scoped query. Show some code? > > -Cameron > > -- > Cameron Childress > -- > p: 678.637.5072 > im: cameroncf > facebook <http://www.facebook.com/cameroncf> | > twitter<http://twitter.com/cameronc> | > google+ <https://profiles.google.com/u/0/117829379451708140985> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:352281 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
