OK....but I require the check box selections to be deleted or appended to the database depening on the OMIT or ADD function. Sure I can omit it from the list but it still exists in the database field "strSelect".
On Mon, 18 Nov 2002 09:22:25 -0500, Randell B Adkins wrote: > In your initial Output for the OMIT Directories try: > > <CFOUTPUT QUERY="thisQ"> > <CFLOOP INDEX=Z LIST="#thisQ.strSelect#"> > <CFIF LISTCONTAINSNOCASE(thisQ.strOmit,Z)> > <!--- Do Not Display This Directory ---> > <CFELSE> > <!--- Display Directory ---> > </CFIF> > </CFLOOP> > </CFOUTPUT> > > Do the same for the ADD section but reverse the query elements. > > > > >>> [EMAIL PROTECTED] 11/18/02 08:09AM >>> > 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
