Here's what I don't understand: As I update the db, it seems like you're telling me to input all 5 values at the same time, correct? If so, then I'll generate an error because of the comma delimited values that are trying to be pushed into a numeric field.
I feel like I'm missing something there. > > Dont have any tutorials.. but i will try to explain it briefly. > > Let say you have a table with a unique identifier/userid/selections as > (fields). > Once you present the user with checkbox options, each > checkbox has a unique > id right? and all checkboxes have the same "name" > > When the user submits the form, you insert 5 selections into > the Table with > the above schema. When the user re-visits the same page, you > show all the > options.. except this time, you have to check the DB > selections to turn > on the checkboxes. > <cfset selections=valueList(QueryName.selections)> > <input type="checkbox" name="mychkBox" value="10" <cfif > listFind(selections,"10")>checked</cfif>> > > Joe Eugene > > > -----Original Message----- > > From: Russ [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, March 05, 2003 12:32 AM > > To: CF-Talk > > Subject: RE: Multiple selections into a DB > > > > > > I think I get what you're saying, but I've never done this > before, so > > I'm a bit at a loss as to how to approach it. > > > > Tutorial? Outline? Example? Any would help! Thanks! > > > > > -----Original Message----- > > > From: Joe Eugene [mailto:[EMAIL PROTECTED] > > > Sent: Tuesday, March 04, 2003 11:22 PM > > > To: CF-Talk > > > Subject: RE: Multiple selections into a DB > > > > > > > > > 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 > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
