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
