From a list of checkboxes, I'm going to collect some user preferences, where each box is assigned a number, and the total comma-delimited numbers placed in a UserPref field.
Later I'll want to verify the user's pref's, but some numbers exceed 100, thus there will be 9,10,11,12,13...109,110,111,112...
When I use the SQL IN statement to verify which pref's the user has, will it get messed up b/c there are multiple instances of "11", "12", etc, and if so, how do I get around this?
Later I'll want to verify the user's pref's, but some numbers exceed 100, thus there will be 9,10,11,12,13...109,110,111,112...
When I use the SQL IN statement to verify which pref's the user has, will it get messed up b/c there are multiple instances of "11", "12", etc, and if so, how do I get around this?
