Do you have a question? i dont understand your post...! Joe
On Thu, 21 Nov 2002 10:24:34 -0500 FlashGuy <[EMAIL PROTECTED]> wrote: > Hi, > > I have a preferences tab which when clicked > queries a database and lists the results on my > page with a checkbox beside each entry. > > The database field would look like this. > > strSelect = > d:\temp\dir1,d:\temp\dir2,d:\temp\dir3,d:\temp\dir4,d:\temp\dir5,d:\temp\dir6,d:\temp\dir7,d:\temp\dir8,d:\temp\dir9,d:\temp\dir10,d:\temp\dir11,d:\temp\dir12,d:\temp > \dir13,d:\temp\dir14,d:\temp\dir15' > > The results get displayed like so. > > [ ] dir1 [ ] dir2 [ ] dir3 > [ ] dir4 [ ] dir5 > [ ] dir6 [ ] dir7 [ ] dir8 > [ ] dir9 [ ] dir10 > [ ] dir11 [ ] dir12 [ ] > dir13 [ ] dir14 [ ] dir15 > > > [UPDATE] > > Any selections made above would be inserted > into the field "strOmit" in my database. > > The next time the Preferences tab is clicked it > should retrieve any previous selections made > and automatically fill in the > appropriate check boxes. To add more, you just > add extra checkmarks and click on update to > update the strOmit field. > > And of course they can uncheck stuff too. Has > to be a way to remove something. > > To remove from the "strOmit" field you uncheck > a box and click update. > > User would check: > > [X] dir1 [ ] dir2 [ ] dir3 > [ ] dir4 [ ] dir5 > [ ] dir6 [ ] dir7 [X] dir8 > [X] dir9 [ ] dir10 > [X] dir11 [ ] dir12 [ ] dir13 > [ ] dir14 [ ] dir15 > > [UPDATE] > > CLick on the update and the following > selections would be inserted into the field > "strOmit". At the same time the page gets > refreshed and any selections inserted into the > "strOmit" field would still be checked. If the > user unchecks a box(s) and clicks on the update > then the database is updated again, screen > refreshed and again the list is > regenerated with the boxes checked based on the > results from the "strOmit" string. > > > > > > --------------------------------------------------- > 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