Serialize them as JSON or WDDX and store them as text. On Wed, Apr 6, 2011 at 1:41 PM, Adam Bourg <adam.bo...@gmail.com> wrote:
> > 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:343573 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm