You might want to just insert the checkbox values into one field rather than having 5 fields for 5 selections.
Once you re-display the page.. you can check these selection ids against your display ids... Its late! hope you get the idea. Joe Eugene > -----Original Message----- > From: Russ [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 05, 2003 12:03 AM > To: CF-Talk > Subject: Multiple selections into a DB > > > I've got a problem to solve and I feel I'm a big portion of the way > there, but I need a little insight into my madness to see how far off I > am and to see if there's an alternate route I should be heading. > > I have a table in my db that provides me with a listing of 15 items. I > display those on a page with a checkbox next to them after polling the > table in the db. Right now, those checkboxes have a value associated > with them that is their AutoNum ID in the db. > > A user, when seeing this page can choose upto 5 of these options, but no > more. There are 5 fields(Field1 ... Field5) in the db that accept these > values that are selected. > > Here's the issues that I'm trying to overcome: > How do I know which of my checkboxes that are selected "go" into Field1, > etc.? > How do I address the SQL issue of saying "these checkboxes should be > checked when the user revisits this page?" > > Those are the big issues--I might be OT here, and I apologize for that. > Any thoughts? > > Thanks, > > Russ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
