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:343572
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
