send to select option from dynamic list

I have an email form with a list populated dynamically from a recordset. I have multiple choices checked on the list and the select value is the recordset column containing the email addresses and the select label is the recordset column containing the corresponding person name.
With UE 3.0.6 i want to be able to select many choices from the list and then send the email form to each selected.
I have used the recordset loop option and it sends to all in the recordset, but when i use the to enter value as the selection from the list and have multiple choices selected, it sends nothing. If i only select one choice, it sends the email to that one choice correctly.

how to do this?

thanks
jim balthrop

You would use DataAssist Search server behavior to filter your recordset based on the list.

Ray

i am not sure how to filter using dataassist search?
the UE server behavior sends to
$RecipientEmail = "".((isset($_POST["select"]))?$_POST["select"]:"") ."";include("WA_Universal_Email/WAUE_email_topgun_group_1.php");

select is the list which allows multiple choices.

so i am not sure how to use DataAssist Search to filter?

thanks for your help,
jim balthrop

here is the page, if that will help.

email_topgun_select.php

You would apply the DataAssist search server behavior on the page with the recordset and universal email server behaviors already applied.

Ray

are you saying DataAssist Wizard or Database Search Wizard?

What am i searching?

Neither wizard. The server behavior. Go to the behaviors panel and click the plus button to select DataAssist->DataAssist Search

Sorry Ray,

i can't find that. Under server behavior i have WA DataAssist > Delete from Database, Insert to Database, Update Database

I have DataAssist 1.3.1

You would need the more recent version of DataAssist.

At the time of DataAssist 1.3.1 we still called this functionality QueryBuilder. If you have Querybuilder you can use that server behavior in the same way.

Ray

i just got the upgrade to DataAssist 2.0.5.
I will try that and see if i can get it to work and get back.

Ray

added serverbehavior DataAssist Search using OR as separator, type as list, comparison as =, and the list field and trigger as rs_emailgroup is not empty
produced session $_SESSION["WADbSearch1_email_topgun_select"]

set the to field in UE as <?php echo $_SESSION['WADbSearch1_email_topgun_select']; ?>

it is redirecting to the page set in UE as the 'go to page'
but no email is sent?

see anything wrong?