<cfif qgetdetails.recordcount> <cfmail ...
</cfif> On Mon, Apr 19, 2010 at 10:52 AM, Damo Drumm <[email protected]>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="[email protected]" > bcc="t...@123,t...@123" > from="[email protected]" > 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:332978 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
