On Mon, 18 Nov 2002 09:48:10 -0500, Randell B Adkins wrote: > When a NEW USER is created, where do you get the Directory listing?
>From an external ASCII text file which gets read in at initial login. A flag is then >set in my database in the field "strSelectFlag" to be "Yes". Next time the user logs in I check that field. If its equal to "Yes" use whats in the "strSelect" field rather than read in the external file. > Is it a Database table? Yes. > Just a Directory Listing on the Server? It is a directory listing but based on the external file. > Or Hard Coded? Nope. > >>> [EMAIL PROTECTED] 11/18/02 09:44AM >>> > 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 Get the mailserver that powers this list at http://www.coolfusion.com
