I think you need to learn procedual programming then. You claim it is not deleting, the reason is simple you delete it at the end. So the item will always appear in your list. You want it removed from your list then, think about the problem and write a flow chart to help you.
Secondly don;t be scared to reuse your query or reread your query if you need too. Conditional statements might be a good idea too, so that if there is nothing posted back to the page then nothing gets deleted. Just an idea. On 2/21/08, erik tom <[EMAIL PROTECTED]> wrote: > >Don't you think it might be better to do at the top of the page the > >check for the item to delete then delete the item? > > > >Rather than at the bottom of the page? > > > >Here is how I see your logic > > > >1) retrieve data > >2) Display data > >3) check for data to be deleted > > > >Can you spot it now? > > > > > > > > If I delete the record from the top it will delete from averywhere , and I > only want t delete for this particular item > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:299585 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
