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

Reply via email to