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:332976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm