Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

new to CF, can you take a look at the code

Status
Not open for further replies.

jeannie322

Programmer
May 18, 2001
25
US
I am trying to do some documentation at work. Can anyone give me a clue as to what is happening in this part of the code? I am very new to CF and would like some help.


<cfset strtoe_code = ''>
<cfloop query=&quot;getOracleData&quot; >
<cfset strtoe_code = strtoe_code & &quot;,&quot; & &quot;'&quot; & #toe_code# & &quot;'&quot;>
</cfloop>
<cfset strtoe_code = #Replace(strtoe_code, &quot;,&quot;, &quot;&quot;)#>

here is the code for the query
<cfquery name=&quot;getOracleORG&quot; datasource = &quot;#ourdatasource#&quot;>
select Distinct ORGANIZATION
from tableX
order by ORGANIZATION
</cfquery>

Thanks!!!
 
It appears as though this code is removing any commas in the result set of the output loop. Yvette Ingram
Brainbench Certified
ColdFusion Application Developer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top