Forums

This topic is locked

Wish list for DWMX

Posted 26 Jun 2002 04:31:50
1
has voted
26 Jun 2002 04:31:50 Kelly Brady posted:
Two things I would love to see in DMX
1) Less code for creating simple Inserts, updates, deletes. Why does there need to be so much code for INSERT INTO, or DELETE FROM?
2) I would love to see a server behavior that would allow you to set one ID according to whatever variable you gave it and then allow you to select multiple choices from a select box and then Insert into a table using the primary ID repeatedly while inserting other ID. Ya right do you get that. Hares the form:

<table width="450" border="0" cellspacing="0" cellpadding="3">
<tr>
<td width="144">Employee Name</td>
<td width="294">
<select name="EmployeeID">
<option value="1">Kelly Brady</option>
<option value="2">Dean Brady</option>
<option value="3">John Hamming</option>
<option value="4">Frank Perdue</option>
<option value="5">Dave Bartlett</option>
<option value="6">Chris Moore</option>
<option value="7">Carrie Robinson</option>
<option value="8">Fred Radley</option>
</select></td>
</tr>
<tr>
<td>Software to buy for this person:</td>
<td>
<select name="SoftwareID" size="5" multiple>
<option value="1">DMX</option>
<option value="2">Microsoft Frontpage</option>
<option value="3">Ultradev 4.0</option>
<option value="4">Java Cafe</option>
<option value="5">HomeSite</option>
</select></td>
</tr>
</table>


Now the users select one Employee and is allowed to select many software programs. Now the table looks like this:

EmployeeID | SoftwareID
1 1
1 4
1 5

Theres the insert. You know a ubound array split type of thing


Reply to this topic