<div>
Thank you very much for your help agx.<br />
I'm sometimes wondering if there would be a better way of doing something.
</div>


Thank you very much for your help agx.
I'm sometimes wondering if there would be a better way of doing something.

<div>
Yes, it's good to check the options when working on a section of code. &nbsp;In this case, that code is probably as good as it gets. As using db functions, does not really buy anything.<br />
<br />
Glad I could help.
</div>


Yes, it's good to check the options when working on a section of code.  In this case, that code is probably as good as it gets. As using db functions, does not really buy anything.

Glad I could help.

<div>
<div class="content wysiwyg-content">
Hello experts .<br />
I need help to output two columns in a list.<br />
I have a code that is working and i'm getting the output i need but i was thinking if i can use another function to 'build' the output (f.e. array).<br />
My code &nbsp;:<br />
<br />
&lt;cfoutput query=&quot;data&quot; group=&quot;#arguments.sorting#<wbr />&quot;&gt; <br />
&nbsp; &nbsp; &nbsp;&lt;cfset ruleslist = ''/&gt;<br />
&nbsp; &nbsp; &nbsp; &lt;cfoutput&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp;&lt;cfset listitem = 'testname_' &amp;&nbsp;testname_id &amp;&nbsp; '=' &amp;&nbsp; testname_value/&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp;&lt;cfset ruleslist = listappend(ruleslist,listi<wbr />tem,'&amp;')/&gt;<wbr /><br />
&nbsp; &nbsp; &nbsp; &lt;/cfoutput&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; #ruleslist#&lt;/br&gt;<br />
&lt;/cfoutput<br />
<br />
Any help?
</div>
</div>


Hello experts .
I need help to output two columns in a list.
I have a code that is working and i'm getting the output i need but i was thinking if i can use another function to 'build' the output (f.e. array).
My code  :

<cfoutput query="data" group="#arguments.sorting#"> 
     <cfset ruleslist = ''/>
      <cfoutput>
       <cfset listitem = 'testname_' & testname_id &  '=' &  testname_value/>
       <cfset ruleslist = listappend(ruleslist,listitem,'&')/>
      </cfoutput>
        #ruleslist#</br>
</cfoutput

Any help?

Coldfusion - query to list question

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.