Yesterday I asked for a way to send multiple emails.  I thank those of you
who responded.

Although the approach works, my client wants the "to" field to show all
users that are sent the message.

I have not done CF for awhile, although not a newbie, perhaps rusty;

First is there a string limit that you can pass via form?
Is there a string limit in CF?

This is my steps:

<CFSET #ToMail#>

<cfquery name="getMail" datastore = "mydatabase" dbtype="ODBC">
Select E_Mail from Contacts
</cfquery>

I thought I could do the following

<cfoutput query ="getMail">
<CFSET #ToMail# = #ToMail# + #E_Mail# + ",">     // can you concatenate a
string?

I would like to remove the last comma
  but I don't remember how ?

I would like to truncate the last  comma(,);

in c the code would be something like
#ToMail# = Mid(#ToMail#,0, Len(#toMail#) -1);



Your help is most appreciated



Kathy Wargo
KMW ASSOCIATES
410-280-2763
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to