Serialize with WDDX or JSON, I would say. Those are complex variable types which need to be serialized into strings before insertion into a DB.
---------------------------------------- From: "Adam Bourg" <[email protected]> Sent: Wednesday, April 06, 2011 1:49 PM To: "cf-talk" <[email protected]> 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:343575 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
