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:352272
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
