if i use like this, if any value is getting null value means all the value is becoming null, how to avoid this
> 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:324643 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
