I am trying to input info into a database and I have a mailer
form above it that supports multiple addresses. Someone suggested
the trim option used below to seperate each line with info however
that doesn't work. I wish to use all the same info in teh database
entry however only put 1 email address per entry even if 5 are
if i understand you correctly, you want to insert only ONE
email address into your db, even if the entry field contains
several comma-separated emails? do not <cfloop> through the
for.recipiants list then. instead use, for example,
'#ListFirst(form.recipiants)#' instead of '#trim(thisAddress)#' in
your INSERT query.
however, if what you want to do is insert A SEPARATE RECORD
for EACH EMAIL ADDRESS in the list, then you have to do something
like (NOTE: i am assuming form.email is a comma-delimited list of
recepients and form.recipiants is a comma-delimeted list of their
<cfloop index="iii" from="1"
<cfquery name="updatetable" datasource="#------#">
INSERT INTO send_to_friend (email, receivers_name,
sendersname, sendersemail, message)
VALUES ('#ListGetAt(form.email, iii)#',
'#ListGetAt(form.recipiants, iii)#', '#form.sendersname#',
IMPORTANT: you will have to implement some serious validation
here to check that the lists of emails/names have more than one
item and that number of items in both lists match!!!