You might want to try forwarding the whole template if it's not classified... without knowing what's in your settings structure or how it's populated / used it's tough to say. It _looks_ like the settings structure contains information that's going to be used in an email and that it's already been populated by the query you would need to modify to get the info you're looking for, but at this point I'm just guessing.
hth s. isaac dealey 214-823-9345 team macromedia volunteer http://www.macromedia.com/go/team chief architect, tapestry cms http://products.turnkey.to onTap is open source http://www.turnkey.to/ontap > 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. ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
