Is this all in one page?
If it is then look at your process flow, it is all wrong dude.
On 2/21/08, erik tom <[EMAIL PROTECTED]> wrote:
> I the form i have 2 drop down . from first when i select the item it
> automatically populate the second drop down. Then if I pick something from
> the second drop down I want to remove that Item from tHe db. tH EPROBLEM IS
> IT SHOULD GET REMOVED from the column called foundOn which is the list.
> <fieldset>
> <h2><b>Add/Remove Items from the list</b></h2>
> <label for="selTopLevel2" style="font-size:12px"><b>List available
> Items</b></label>
> <select name="selTopLevel2" id="selTopLevel2" >
> <option value="">Please select one</option>
> <cfoutput query="topMenu">
> <option value="#menuId#">#label#</option>
> </cfoutput>
> </select>
>
> <input type="submit" name="showSeleted" id="showSelected" value="Pick
> Selected" /><br />
> <!---Populate items based on seletion--->
> <cfif structKeyExists(form,"selTopLevel2")>
>
> <table width="700" align="center">
> <tr>
> <th width="275" scope="col">Items that has
> been assigned </th>
> <th scope="col"> </th>
> <th width="275" scope="col">All Items</th>
> </tr>
> <tr>
> <td width="275" align="center" valign="top">
> <select name="assignedTo" id="assignedTo" multiple="multiple">
> <cfoutput>
> <cfloop query="topMenuAssigned">
> <option value="#menuId#">#label#</option>
> </cfloop>
> </cfoutput>
> </select>
> </td>
> <td align="center" valign="top">
> <br/>
>
> <input type="submit"
> name="btnRemoveItem" id="btnRemoveItem" value="-" alt="Remove Item"/>
>
>
> <input type="submit" name="btnAddItem"
> id="btnAddItem" value="+" alt="Add Item"/>
> </td>
> <td width="275" align="center" valign="top">
>
> <select name="showAllItems" id="showAllItems" multiple="multiple">
> <cfoutput query="topMenu">
> <option value="#menuId#">#label#</option>
> </cfoutput>
> </select>
> </td>
> </tr>
> </table>
> <br />
> <cfelse>
> <cfabort>
> <p style="color:red">Nothing was selected</p>
>
> </cfif>
> <!---End of Populate items based on seletion--->
>
>
>
> </fieldset>
> <cfif isDefined("form.btnRemoveItem")>
> <cfquery name="remFromList" datasource="cfelsunrise" dbtype="ODBC">
> select foundOn from menu where menuId=#form.selTopLevel2#
>
>
> </cfquery>
>
> <cfset myLsit=ValueList(remFromList.foundOn)>
>
> <cfset newList=ListFind(myLsit,form.assignedTo)>
> <cfif newList is 1>
> <cfloop From = "1" To = "#ListLen(newList)#" index = "Counter">
> <cfset newList2=ListDeleteAt(newLIst,ListGetAt(newList, Counter))>
> </cfloop>
>
> </cfif>
> <cfquery name="removeFromList" datasource="cfelsunrise" dbtype="ODBC">
> update dbo.Menu
> set foundOn=#newList2#
> where menuId=#form.selTopLevel2#
>
> </cfquery>
>
> </cfif>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299559
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
