thanks for the replies, this works perfectly
>listVar = left(repeatString("VarChar,", arrayLen(arrayVar)), ((8 * >arrayLen(arrayVar)) - 1)); > >that just creates a list of "VarChar,VarChar,VarChar," based on the >arrayLen() and then removes the final ",". ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:325080 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4