.....and another question.....why are you getting the duplicates? I would suspect that those values should be individual records ina lookup table (i.e. a lookup table is often used to store options like red,green, blue OR a list of cities, or a list of product sizes etc.)
That "lookup" or "list" data is often then stored in a transactional record (i.e. an employee record where you are recording their home address....you store the foreign key to the record in the list table). So let's say that New York is has a record ID of 5....you would store 5 in the city_id column in the employee record. So what's your data structure behind the data you are returning? Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ----- Original Message ----- From: "Paul Smith" <[EMAIL PROTECTED]> To: "SQL" <[email protected]> Sent: Tuesday, August 28, 2007 4:27 PM Subject: CFselect - need to remove duplicates, how? > ok im a complete newbie at sql, I bet you have heard that a 1000 times :) > > anyways I have my db set up and I am using the cfselect command to create a > user selection box from the returned data, however the returned data contains > many duplicates (which is correct) but I want to remove these duplicates, is > there a simple way of doing it > > e.g. > > wales > wales > wales > people > people > many > many > many > many > > is the returned data in the selection list and I want it to return > > wales > people > many > > I guess there will be a simple answer to this but I am blowed if I can find it > > anyways thanks for looking. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2917 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
