CFIF Query

[Brent Evans]

I am trying to setup a query to our database that will flag orders that have been placed with 3 or more in the quantity of an individual item (as opposed to 3 or more in total order quantity). How would I go about modifying the following code to include verifying that the quantity flag is set for an individual product found in the order?   <!--- send the notification for orders with 3 or more in quantity of one product ---> <cfif isdefined("baskets.product_code") and baskets.quantity lt 3>             <cfset variables.recipients = settings.order_notification_recipients>             <cfset variables.subject = settings.order_notification_subject> <cfelse>             <cfset variables.recipients = settings.order_notification_recipients_quantity3>             <cfset variables.subject = settings.order_notification_subject_quantity3> </cfif>   Let me know if any other info is needed.   Thanks, Brent E.