I'm trying to use the CF_DualSelect tag that I got a while back (thank you to who wrote it). I'm having some basic SQL/CF problems that are really hampering my progress on a particular page. I keep procrastinating, and, well, the deadline is SOON. I have 3 tables, to keep it simple, I'll provide minimal data for each: This table contains the full english name of the 'careercode' in the next table. 'menucode' on this table is the same as 'careercode' on the next. 'Category' table ---------------------------------- menuname menucode ---------------------------------- Academic ACAD Firefighter FIRE Postal Services POST ---------------------------------- This table contains all the newsletters, and the unique ID for each, with the 'careercode' related to 'menucode in the table above. 'Newsletters' table ---------------------------------- careercode newsletterid --------------------------------- fire 1 post 2 acad 3 fire 4 acad 5 ---------------------------------- This table contains the subscriptions, with the 'userid' being repeated as many times as necessary, depending on how many different newsletters (s)he is subscribed to. 'Subscribers' table ---------------------------------- userid newsletterid ----------------------------------- 1 1 1 2 ---------------------------------- Now, I need to populate 4 lists: 'Right' (a list of the 'menunames' that the user is subscribed to) 'Right_Values' (a list (in the same order as the above 'Right') of 'newsletterid' that the user is subscribed to, what i'm going to insert into the database) 'Left' (a list of the 'menunames' that the user is NOT subscribed to) 'Left_Values' (a list (in the same order as above 'Left') of 'newsletterid' that the user is NOT subscribed to) I have a feeling I'm making this out to be more difficult then it is, but I got myself so frustrated... you know how it goes. Anyone care to give me a hand with this? I'd appreciate any suggestions. Thanks all, ~kilo ===== ~~~~ "A flaw in the human character is that everybody wants to build and nobody wants to do maintenance." Kurt Vonnegut, Hocus Pocus ~~~~ __________________________________________________ Do You Yahoo!? Get Yahoo! Mail � Free email you can access from anywhere! http://mail.yahoo.com/ ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
