Return to Snippet

Revision: 58075
at June 23, 2012 15:47 by nuukem


Updated Code
<h3>From a Query</h3>

<cfquery name="settingsParameters" datasource="#dsn#">
	SELECT NAME, VALUE
	FROM MY_SETTINGS
	WHERE ACTIVE = 1
	AND SECTION = 'whatsNew'
</cfquery>

<!--- To output the results use one of these 2 mothods.  The latter is the newer, simpler way to write it --->
<cfloop query="settingsParameters">
	<cfset temp2 = SetVariable("settings.#settingsParameters.name#", settingsParameters.value) />
</cfloop>

<!--- OR, CF >= 8 (i  think) --->

<cfloop query="settingsParameters">
	<cfset "settings.#settingsParameters.name#" = settingsParameters.value >
</cfloop>


<h3>From a list</h3>

<cfset myList = "something=blah;what=now;who=jim">
    
<!--- Loop over list breaking it up on semicolon. create a temp array and use array[1] for the name of the variable and array[2] as the value i.e. bupid=7; creates <cfset additionalParams.bupid = 7> --->

<cfloop list="#myList#" delimiters=";" index="i">
	<cfset k = listToArray(i,"=")>
	<cfset "additionalParams.#k[1]#" = k[2] \>
</cfloop>

Revision: 58074
at June 23, 2012 15:45 by nuukem


Initial Code
<h3>From a Query</h3>

<cfquery name="settingsParameters" datasource="#dsn#">
	SELECT NAME, VALUE
	FROM MY_SETTINGS
	WHERE ACTIVE = 1
	AND SECTION = 'whatsNew'
</cfquery>

<!--- To output the results use one of these 2 mothods.  The latter is the newer, simpler way to write it --->
<cfloop query="settingsParameters">
	<cfset temp2 = SetVariable("settings.#settingsParameters.name#", settingsParameters.value) />
</cfloop>

<!--- OR, CF >= 8 (i  think) --->

<cfloop query="settingsParameters">
	<cfset "settings.#settingsParameters.name#" = settingsParameters.value >
</cfloop>





<h3>From a list</h3>


<cfset myList = "something=blah;what=now;who=jim">
    
<!--- Loop over list breaking it up on semicolon. create a temp array and use array[1] for the name of the variable and 

array[2] as the value i.e. bupid=7; creates <cfset additionalParams.bupid = 7> --->

<cfloop list="#myList#" delimiters=";" index="i">
	<cfset k = listToArray(i,"=")>
	<cfset "additionalParams.#k[1]#" = k[2] \>
</cfloop>

Initial URL

                                

Initial Description
Create dynamic variables from a query or a list.

Initial Title
Creating Dynamic Variables

Initial Tags

                                

Initial Language
ColdFusion