<cfquery datasource="#DSN#" name="qMyDiscountApprovals">
SELECT *
FROM Bookings, BookingItems
WHERE BO_DeleteDate IS NULL
AND BO_ID = BI_BookingID
AND BI_ParentItem IS NULL
<cfif Client.Authenticate eq 2>
and BO_Discount >= 0.03
<cfelseif Client.Authenticate eq 3>
and BO_Discount >= 0.03 AND BO_Discount <= 0.07
</cfif>
and BO_DiscountApproval is NULL
</cfquery>
Now the above code returns 23 and the actual query above returns 73, I know
it has something to do with the group="bo_id" just can't work it out?
Just a thought, but when you are using <cfoutput> with the group attribute, don't you usually include a GROUP BY clause in your query?
Not sure if that's helpful or not...
Cheers,
Seona.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
