jeannie322
Programmer
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="getOracleData" >
<cfset strtoe_code = strtoe_code & "," & "'" & #toe_code# & "'">
</cfloop>
<cfset strtoe_code = #Replace(strtoe_code, ",", ""#>
here is the code for the query
<cfquery name="getOracleORG" datasource = "#ourdatasource#">
select Distinct ORGANIZATION
from tableX
order by ORGANIZATION
</cfquery>
Thanks!!!
<cfset strtoe_code = ''>
<cfloop query="getOracleData" >
<cfset strtoe_code = strtoe_code & "," & "'" & #toe_code# & "'">
</cfloop>
<cfset strtoe_code = #Replace(strtoe_code, ",", ""#>
here is the code for the query
<cfquery name="getOracleORG" datasource = "#ourdatasource#">
select Distinct ORGANIZATION
from tableX
order by ORGANIZATION
</cfquery>
Thanks!!!