Data Bridge update page dynamic select issue
Environment: Windows 7
Dreamweaver CS6
DataBridge 1.0.7
Issue: Insert page has a few dynamic select boxes, which work just fine. The update page in DataBridge shows the dynamic select boxes just as it did for the Insert page. However when I click on a record on results page, it takes me to the update page and all other fields are showing the correct information based on what was in the record, but the dynamic select boxes are not setting the selected value to what is in the record. I verified via the results and detail page that the data is there. Any idea as to the issue?
I have attempted resolution by:
Deleting winfile
Uninstalling and reinstalling DataBridge
Example dynamic select box created on Update page
<select class="formMenufield_Medium" name="dealtype" id="dealtype" tabindex="2" onChange="hideServerError('dealtype_ServerError');">
<option value=""> </option>
<?php
do {
?>
<option value="<?php echo $row_WADAMenudealtype['dtypename']?>"<?php if (!(strcmp($row_WADAMenudealtype['dtypename'], (isset($_GET["invalid"])?ValidatedField("index","dealtype"):"".$row_WADADeal["dealtype"]."")))) {"selected=\"selected\"";} ?>><?php echo $row_WADAMenudealtype['dtypename']?></option>
<?php
} while ($row_WADAMenudealtype = mysql_fetch_assoc($WADAMenudealtype));
$rows = mysql_num_rows($WADAMenudealtype);
if($rows > 0) {
mysql_data_seek($WADAMenudealtype, 0);
$row_WADAMenudealtype = mysql_fetch_assoc($WADAMenudealtype);
}
?>
</select>
Known solution (however not preferred)
Open Dynamic List Menu in Dreamweaver and change the Select value equal to box to <?php echo $row_WADAMenudealtype['dtypename']; ?>
I would really rather not have to do this on every update page I create with dynamic select menus (quite a few of them). I am starting a rather large intranet project where I will be utilizing DataBridge (DataAssist) a lot.
Any help would be appreciated.