just add a <cfif> around the mail <cfif qgetdetails.recordcount gt 0>
<cfmail..... </cfmail> </cfif> Rob On Mon, Apr 19, 2010 at 11:52 AM, Damo Drumm <damien.dr...@quinn-group.com>wrote: > > Hi > Ive the below code and im trying to get it to check first that the > confirmation field in the comments table is equal to 1 before it send > > at the minute its sending anyway > > any tips > Thanks > > <cfquery name="qgetdetails" datasource="#test#"> > Select * > From comments > where confirmation = 1 > </cfquery> > > > <cfmail to="t...@123.com" > bcc="t...@123,t...@123" > from="m...@test.com" > subject="Test" > > > Persons Name:#Name# > Persons Email:#Email# > Comments:#comments# > </cfmail> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332979 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm