Hi, I'm hoping I can explain this better so here it goes. I'm using ColdFusion and MySQL. 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 --------------------------------------------------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
