Hi, I'm hoping I can explain this better so here it goes. My database has the following fields and what they contain:
strUser_ID (auto-generated) strUsername = 'Bill' strSelect = 'D:\test\dir1,D:\test\dir2,D:\test\dir3,D:\test\dir4,D:\test\dir5' strSelectFlag = '' strOmit = 'D:\test\dir2,D:\test\dir4 My <cfquery output would look like this: To OMIT directory(s) click on a checkbox below: [ ] dir1 [ ] dir2 [ ] dir3 [ ] dir4 [ ] dir5 To ADD directory(s) click on a checkbox below: [ ] dir2 [ ] dir3 [ ] dir4 The problem I'm having is getting the selection from the OMIT checkbox deleted from the database. Can I easily do a match of the string and delete them? The output should *really* be this and visa-versa if checkboxes are checked in the ADD directory section. To OMIT directory(s) click on a checkbox below: [ ] dir1 [ ] dir5 To ADD directory(s) click on a checkbox below: [ ] dir2 [ ] dir3 [ ] dir4 --------------------------------------------------- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
