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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
