form within cc

I have 4 postfix MTAs setup to read relay_domains and recipient_maps from mysql. Because of how postfix works these have to be separate tables. Relay_domains is simply a list of domains (example1.com, example2.com) and recipient_maps is just a list of email addresses. When inserting an email address in to recipient_maps from a form I would like to be able to select the domain portion from a drop down list pulled from relay_domains, concatenate from the input box, an @ and the list selection to form an email address and then insert in to recipient_maps.

Can this be done in CC?

I'm hoping to avoid building it in php and using a wrapper. I've spent all me years in networking, email and sql servers....php is not something I'm looking forward to =(

Hi chaotic,

Most of your post means nothing to me :-(

Where do you want the drop-down list? It sounds as though you want it in a form rather than in a ChronoConnectivity list?

Bob

PS Ah I've found MTA and Postfix - doesn't help a lot though.

Hi Bob,
Thanks for the reply. I looked in to doing this in CF, but it doesn't look like its possible right now. What I need is a form with a dropdown list populated from table_1. The form will submit results that go in to table_2.

This would be easier were it not for the way Postfix uses a database and if I knew php =)

Randy

Hi Randy,

I'm still not clear but here's an example from a CC 'Header' box:

<?php
$db =& JFactory::getDBO();

$filter =& JRequest::getString('filter', '', 'post');
$event =& JRequest::getString('eventement', '', 'post');

// set event search
$query = "
SELECT `cf_id`, `event_name`
  FROM `#__gh_evenementen`
  ORDER BY `event_name`
";
$db->setQuery($query);
$eventement = $db->loadAssocList();
//echo '<div>$eventement; '.print_r($eventement, true).'</div>';
$event_options = "";
foreach ( $eventement as $v ) {
  if ( $v['cf_id'] == $event ) {
    $selected = "selected='selected'";
  } else {
    $selected = '';
  }
  $event_options .= "<option value='".$v['cf_id']."' $selected >".$v['event_name']."</option>";
}

?>
<div class="form_item">
  <div class="form_element cf_dropdown">
    <label class="cf_label" style="width: 150px;">Zoek voor dit evenement</label>
    <select class="cf_inputbox" id="eventement" size="1" title=""  name="eventement">
    <option value="">Kies een evenement</option>
<?php
echo $event_options;
?>
    </select>
  </div>
  <div class="cfclear"> </div>
</div>
<div>
    <label for='filter' class='cf_label' >Zoek im besicht</label>
    <input type='text' name='filter' id='filter' value='<?php echo $filter; ?>' />
</div>
<div>
    <input type='submit' name='filter_submit' value='Zoeken' /> 
    <input type='button' name='filter_reset' value='Reset' onClick='this.form.filter.value=""; this.form.eventement.selectedIndex = 0;'/>
</div>

Bob