Assuming that your query is returning a boolean field that indicates the include state, you could order on this field and use the GROUP option of the CFOUTPUT tag and some conditional logic to control formatting the output.
Pseudo-example Code: <cfoutput query="myquery"> <cfif myquery.showthis> Preferences: (Click to omit directories from listing) <cfelse> Preferences: (Click to add directories to listing) </cfif> <cfoutput group="showthis"> <!--- your form input code here ---> </cfoutput> </cfoutput> At 09:48 AM 11/14/2002 -0500, you wrote: >Hi, > >I have a preferences page that lists directories with check boxes. This is >displaying by querying my database. It looks something like this: > >Preferences: (Click to omit directories from listing) > >[ ] dir1 >[ ] dir2 >[ ] dir3 >[ ] dir4 >[ ] dir5 > >[ UPDATE ] > >Preferences: (Click to add directories to listing) > >No directories selected. > >[ UPDATE ] > > >So if the user checked on boxes dir2 and dir4 and clicks on the "update" I >then want the screen to appear like: > >[ ] dir1 >[ ] dir3 >[ ] dir5 > >[ UPDATE ] > >Preferences: (Click to add directories to listing) > >[ ] dir2 >[ ] dir4 > >[ UPDATE ] > >I'm not how to make this happen using my queries? > > >--------------------------------------------------- >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