asked on
ColdFusion Convert Query to an Array for Shuffle
Currently we have an array that spits out in a footer to shuffle our site sponsors
<cfset arrSponsors = ListToArray(
'<a href="http://www.fmanet.org/memberdirectory/member-details.cfm?id=102951">Clark Metal Products Co.</a>,
<a href="http://www.fmanet.org/memberdirectory/member-details.cfm?id=139608">General Sheet Metal Works Inc.</a>
')/>
<cfset CreateObject("java","java.
<cfoutput>
<cfloop array="#arrSponsors#" index="i">
<dd>#i#</dd>
</cfloop>
</cfoutput>
If I want to replace the hard-coded list with a query how do I get that to shuffle?
<cfloop query = "getSupporters">
<cfoutput>
<dd><a href="#getSupporters.SiteS
</cfoutput>
</cfloop>
<cfset arrSponsors = ListToArray(
'<a href="http://www.fmanet.org/memberdirectory/member-details.cfm?id=102951">Clark Metal Products Co.</a>,
<a href="http://www.fmanet.org/memberdirectory/member-details.cfm?id=139608">General Sheet Metal Works Inc.</a>
')/>
<cfset CreateObject("java","java.
<cfoutput>
<cfloop array="#arrSponsors#" index="i">
<dd>#i#</dd>
</cfloop>
</cfoutput>
If I want to replace the hard-coded list with a query how do I get that to shuffle?
<cfloop query = "getSupporters">
<cfoutput>
<dd><a href="#getSupporters.SiteS
</cfoutput>
</cfloop>
ColdFusion Language
Last Comment
_agx_
.. or you could generate an array of row numbers and shuffle that. Then loop through the array and output the columns using array notation.
...
<cfloop from="1" to="#arrayLen(variables.ro
<cfset row = variables.rowNumbers[x]>
<cfoutput>
<dd><a href="#getSupporters.SiteS
</cfoutput>
</cfloop>
...
<cfloop from="1" to="#arrayLen(variables.ro
<cfset row = variables.rowNumbers[x]>
<cfoutput>
<dd><a href="#getSupporters.SiteS
</cfoutput>
</cfloop>
ASKER
This solution generates the following error:
Element ROWNUMBERS is undefined in VARIABLES.
Yeah, like I said you have to generate an array of row numbers and shuffle() it first ;-) It's just a simple cfloop from 1 to the query.recordCount and appending the counter number to the array.
ASKER
ah ok will do
ASKER
ok, I am completely confused as how to "generate an array of row numbers and shuffle() "
:/
:/
ASKER
For now I just threw this in
<cfquery name="getSupporters" datasource="#APPLICATION.D
SELECT SupporterID, Name, URL
FROM tFMA_SiteSupporters
ORDER BY newid()
</cfquery>
<cfquery name="getSupporters" datasource="#APPLICATION.D
SELECT SupporterID, Name, URL
FROM tFMA_SiteSupporters
ORDER BY newid()
</cfquery>
ASKER
Is this the syntax?
<cfloop list="#getSupporters#" from="1" to="#getSupporters.recordC
</cfloop>
<cfloop list="#getSupporters#" from="1" to="#getSupporters.recordC
</cfloop>
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
>> Is this the syntax?
No, it's just your basic from/to loop :)
<cfloop from="1" to="#getSupporters.recordC
But don't bother with a loop The query solution you posted is better :)
No, it's just your basic from/to loop :)
<cfloop from="1" to="#getSupporters.recordC
But don't bother with a loop The query solution you posted is better :)
ASKER
Awesome! yay! :)
Thanks for the points, but I would have accepted your answer because it was "the best solution" here :)
ASKER
ok NOW you are just going to make me blush *laugh* :)
LOL. No need to be modest. It's just the truth :) (Honestly, I'm feeling a little silly I forgot about that approach. But hey, you've got to be able to admit when you're wrong ;-)
Cheers
Cheers
http://www.cflib.org/udf/QueryRandomRows