Hi I am using the three select related select box. I have one table, which has,
State | City | Name fields. The CustomTag works fine, except there are multiple states are showing in the first select box. how can I get the Distinct value of the states <CFQUERY DATASOURCE="#DSN#" NAME="TestQuery"> SELECT * FROM List </CFQUERY> <CF_ThreeSelectsRelated Query="TestQuery" Display1="State" Display2="City" Display3="Name" Value1="State" Value2="City" Value3="Name" EmptyText1="Pick a State" EmptyText2="Pick a City" Emptytext3="Pick a Name"> -- Regards, ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208620 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
