If you have to go down that path you can use serializeJson eg: <cfset tmpArray = ['aaa', 'bbb', 'ccc'] />
<cfset jsonArrayData = serializeJSON(tmpArray) /> <cfoutput>#jsonArrayData#</cfoutput> <cfdump var="#deserializeJSON(jsonArrayData)#" /> Paul. On 27/06/2012 9:43 AM, Rob Voyle wrote: > Hi Folks > > I have a shopping cart that creates a multi-item order as a two dimensional > array. > > What is the best way to put all the array data in one cell of a mysql > database. > > Lots of conflicting advice on the web. > > Thanks > Rob > Robert J. Voyle, Psy.D. > Director, Clergy Leadership Institute > For Coaching and Training in Appreciative Inquiry > Author: Restoring Hope: Appreciative Strategies > to Resolve Grief and Resentment > http://www.appreciativeway.com/ > 503-647-2378 or 503-647-2382 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5863 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
