I tried that and it still does not exist.
On Wed, Aug 22, 2012 at 4:57 PM, Alan Rother <alan.rot...@gmail.com> wrote:
>
> Try explicitly scoping the variable
>
> As in variables.PastDueInvoices - first its just good form, second it does
> make the app run faster, as when you don't provide the explicit scope, CF
> has to check through a number of scopes for it. It could also explain the
> issue - if for example anywhere else in your app you are using that var
> name in say, Application, Server, Request or Session scope.
>
> On Wed, Aug 22, 2012 at 2:51 PM, Brian Cain <bcc9...@gmail.com> wrote:
>
> >
> > 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 <camer...@gmail.com
> > >wrote:
> >
> > >
> > > On Wed, Aug 22, 2012 at 5:38 PM, Brian Cain <bcc9...@gmail.com> 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:352274
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
