Dave - This might sound obvious, but are you sure that session.RecordID is being set properly? Are you sure that your query has records?
Try outputting the variables on screen just to check. If you comment out the <cfif> statement will it work? I usually try commenting out one piece of the code at a time until it works, and that helps me to find the problem. Your cfmail tag looks fine to me. Melissa Dave Clay wrote: > Any ideas why this will wount work in CF 5: > > <CFQUERY name="getEmail" dataSource="AUTOMATION" maxRows=1> > SELECT * > FROM Jobs > WHERE RecID = #session.RecordID# > </CFQUERY> > > <CFIF #getEmail.status# EQ 4> > > <cfmail query="getEmail" to="#email#" from="[EMAIL PROTECTED]" > subject="Work Order Submission">The #trim(getEmail.ProjectName)# work > order has been completed. Please double check your request is completed > to your satisfaction.</cfmail> > </cfif> > > And why this does to the "to" with a static email address? > > <CFQUERY name="getEmail" dataSource="AUTOMATION" maxRows=1> > SELECT * > FROM Jobs > WHERE RecID = #session.RecordID# > </CFQUERY> > > <CFIF #getEmail.status# EQ 4> > > <cfmail query="getEmail" to="[EMAIL PROTECTED]" > from="[EMAIL PROTECTED]" subject="Work Order Submission">The > #trim(getEmail.ProjectName)# work order has been completed. Please > double check your request is completed to your satisfaction.</cfmail> > </cfif> > > Any help would be greatly appreiated. > Thank you > > Dave Clay > trusjoist.com > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
