cf database and null values .. please help

[egiblock]

<CFMAIL
From="#yourname# - #CompanyName# - (#areacode#)#phonenumber#"
To="egiblock@runbox.com, #email2#"
Subject="ds2 test results"
Type="html">


#email2# is pulled from the database, but may have nothing in the line of the database....

i was wondering how to write the code that if there is no value for #email2# to just send to the first email address...

if i don't have a value for the second email address i get the following error:



Error resolving parameter EMAIL2


ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either:

1. You have misspelled the parameter name, or
2. You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag.


The error occurred while processing an element with a general identifier of (CFMAIL), occupying document position (12:3) to (17:1).

[Wbmstr84]

not sure what language this is but can u cynamically set up a to string and then send that.

for example
tostring = "egiblock@runbox.com"

if #email2# not null or ""

tostring = tostring & #email2#

[egiblock]

coldfusion

[ownersite]

How about trying...

<CFIF IsDefined("email2") AND email2 GT "">,#email2#</CFIF> or <CFIF email2 GT "">,#email2#</CFIF> 

Note that the comma is within the <CFIF> tags.