Just talked about this today with a colleague. Convert it to JSON and store that. When you need to use it, get it from the database and "deseralize" it.
.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -----Original Message----- From: Adam Bourg [mailto:adam.bo...@gmail.com] Sent: Wednesday, April 06, 2011 1:41 PM To: cf-talk Subject: Storing Arrays or Structures in a database I've got really large sets of data that are related to each day of the week and the hour. Rather then creating a massive table containing these values, I have stored them in a Structure, but I can't seem to get Structures or Arrays to insert into a database. How can I store an array or structure in a MS 2008 SQL server? Array Code: <cfset name="Adam" /> <cfscript> // 7 days, day 0 = Mon, Day 7 = sun workWeek=["t","t","f","t","f","t","f"]; </cfscript> <cfinvoke method="injectData" component="anubis"> <cfinvokeargument name="name" value="#name#" /> <cfinvokeargument name="workWeek" value="#workWeek#" /> </cfinvoke> <cffunction name="injectData" access="public" returntype="void" hint="Injects the Employee App form data"> <cfquery datasource="DSN" name="insertData"> INSERT INTO mod_employmentAppProfile( name, workWeekendsEvenings ) VALUES ( #ARGUMENTS.name#, #ARGUMENTS.workWeek# ) </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343584 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm