Creating A Dymanic CFMAIL Tag

[JBishop]

I am creating an automatic email system for several clients; some which have an
e-mail server we can use and some that requires a username and passord.

I am trying to figure out the best way to develop a cfmail tag which is
custimized to their email server settings, since we can not use cfif or the
#if# item inside the cfmail tag itself. I have posted what I am trying to
accomplish with cfmail and cfif.

Is there a better way to do this rather than writing several cfmail tags with
different cfif senarios?

Thanks! Jeremy

<cfquery name="getemailserverinfo" datasource="#ds#">
SELECT client_emailserver_server, client_emailserver_port,
client_emailserver_timeout, client_emailserver_username,
client_emailserver_password, client_emailserver_mailerid
FROM client_emailserver
WHERE webbase_id = <cfqueryparam cfsqltype="cf_sql_integer"
value="#webbase_id#">
</cfquery>

<cfmail
<cfif getmailserverinfo.recordcount is not 0>
<cfif trim(getmailserverinfo.client_emailserver_server) is not ''>
server="#trim(getmailserverinfo.client_emailserver _server)#"
</cfif>
<cfif trim(getmailserverinfo.client_emailserver_port) is not ''>
port="#trim(getmailserverinfo.client_emailserver_p ort)#"
</cfif>
<cfif trim(getmailserverinfo.client_emailserver_timeout) is not ''>
timeout="#trim(getmailserverinfo.client_emailserve r_timeout)#"
</cfif>
<cfif trim(getmailserverinfo.client_emailserver_username ) is not ''>
username="#trim(getmailserverinfo.client_emailserv er_username)#"
</cfif>
<cfif trim(getmailserverinfo.client_emailserver_password ) is not ''>
password="#trim(getmailserverinfo.client_emailserv er_password)#"
</cfif>
<cfif trim(getmailserverinfo.client_emailserver_mailerid ) is not ''>
mailerid="#trim(getmailserverinfo.client_emailserv er_mailerid)#"
</cfif>
</cfif>
query="grab_webbaseusers" type="html" to="""#trim(webbaseuser_firstname)#
#trim(webbaseuser_lastname)#"" <#trim(webbaseuser_email)#>"
from="""#trim(getclientemailinfo.client_name)#""
<#trim(getclientemailinfo.recentchanges_emailaddre ss)#>"
subject="#trim(form.emailsubject)#">
#form.emailmessage#
<br><br>
#cfhttp.FileContent#

</cfmail>

[JBishop]

I am creating an automatic email system for several clients; some which have an
e-mail server we can use and some that requires a username and passord.

I am trying to figure out the best way to develop a cfmail tag which is
custimized to their email server settings, since we can not use cfif or the
#if# item inside the cfmail tag itself. I have posted what I am trying to
accomplish with cfmail and cfif.

Is there a better way to do this rather than writing several cfmail tags with
different cfif senarios?

Thanks! Jeremy

<cfquery name="getemailserverinfo" datasource="#ds#">
SELECT client_emailserver_server, client_emailserver_port,
client_emailserver_timeout, client_emailserver_username,
client_emailserver_password, client_emailserver_mailerid
FROM client_emailserver
WHERE webbase_id = <cfqueryparam cfsqltype="cf_sql_integer"
value="#webbase_id#">
</cfquery>

<cfmail
<cfif getmailserverinfo.recordcount is not 0>
<cfif trim(getmailserverinfo.client_emailserver_server) is not ''>
server="#trim(getmailserverinfo.client_emailserver _server)#"
</cfif>
<cfif trim(getmailserverinfo.client_emailserver_port) is not ''>
port="#trim(getmailserverinfo.client_emailserver_p ort)#"
</cfif>
<cfif trim(getmailserverinfo.client_emailserver_timeout) is not ''>
timeout="#trim(getmailserverinfo.client_emailserve r_timeout)#"
</cfif>
<cfif trim(getmailserverinfo.client_emailserver_username ) is not ''>
username="#trim(getmailserverinfo.client_emailserv er_username)#"
</cfif>
<cfif trim(getmailserverinfo.client_emailserver_password ) is not ''>
password="#trim(getmailserverinfo.client_emailserv er_password)#"
</cfif>
<cfif trim(getmailserverinfo.client_emailserver_mailerid ) is not ''>
mailerid="#trim(getmailserverinfo.client_emailserv er_mailerid)#"
</cfif>
</cfif>
query="grab_webbaseusers" type="html" to="""#trim(webbaseuser_firstname)#
#trim(webbaseuser_lastname)#"" <#trim(webbaseuser_email)#>"
from="""#trim(getclientemailinfo.client_name)#""
<#trim(getclientemailinfo.recentchanges_emailaddre ss)#>"
subject="#trim(form.emailsubject)#">
#form.emailmessage#
<br><br>
#cfhttp.FileContent#

</cfmail>

[futureman]

maybe not the most efficient but I would probably do it like this:

<cfquery name="getemailserverinfo" datasource="#ds#">
SELECT client_emailserver_server, client_emailserver_port,
client_emailserver_timeout, client_emailserver_username,
client_emailserver_password, client_emailserver_mailerid
FROM client_emailserver
WHERE webbase_id = <cfqueryparam cfsqltype="cf_sql_integer"
value="#webbase_id#">
</cfquery>

<cfif getmailserverinfo.recordcount is not 0>
<cfif trim(getmailserverinfo.client_emailserver_server) is not ''>
<cfset server = #trim(getmailserverinfo.client_emailserver_server) #>
</cfif>
<cfif trim(getmailserverinfo.client_emailserver_port) is not ''>
<cfset port = #trim(getmailserverinfo.client_emailserver_port)#>
</cfif>
<cfif trim(getmailserverinfo.client_emailserver_timeout) is not ''>
<cfset timeout = #trim(getmailserverinfo.client_emailserver_timeout )#>
</cfif>
<cfif trim(getmailserverinfo.client_emailserver_username ) is not ''>
<cfset username = #trim(getmailserverinfo.client_emailserver_usernam e)#>
</cfif>
<cfif trim(getmailserverinfo.client_emailserver_password ) is not ''>
<cfset password = #trim(getmailserverinfo.client_emailserver_passwor d)#>
</cfif>
<cfif trim(getmailserverinfo.client_emailserver_mailerid ) is not ''>
<cfset mailerid = #trim(getmailserverinfo.client_emailserver_maileri d)#>
</cfif>


<cfmail server="#server#" port="#port#" timeout="#timeout#"
username="#username#" password="#password#" mailerid="#mailerid#"
query="grab_webbaseusers" type="html" to="""#trim(webbaseuser_firstname)#
#trim(webbaseuser_lastname)#"" <#trim(webbaseuser_email)#>"
from="""#trim(getclientemailinfo.client_name)#""
<#trim(getclientemailinfo.recentchanges_emailaddre ss)#>"
subject="#trim(form.emailsubject)#">
#form.emailmessage#
<br><br>
#cfhttp.FileContent#

</cfmail>
<cfelse>


<cfmail query="grab_webbaseusers" type="html"
to="""#trim(webbaseuser_firstname)# #trim(webbaseuser_lastname)#""
<#trim(webbaseuser_email)#>" from="""#trim(getclientemailinfo.client_name)#""
<#trim(getclientemailinfo.recentchanges_emailaddre ss)#>"
subject="#trim(form.emailsubject)#">
#form.emailmessage#
<br><br>
#cfhttp.FileContent#

</cfmail>
</cfif>