concatenate the 3 columns into one in your query. eg: SELECT address1 + ', ' + address2 + ', ' + address3 AS address FROM sometable
Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 17/07/2009 17:42, RamaDevi Dobbala wrote: > Hi frnds, > > i need to pass address column to cfgrid column, but in my table i have 3 > columns for that address(address,state,city), but while displaying i have to > keep these three into the CFGRIDCOLUMN how to give that. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324638 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
