Mura CMS - dspCountiesList from external DB (add to contentRenderer.cfc)

dspCountiesList

	<!--- dspCountiesList - JE added 20181013 --->
	<cffunction name="dspCountiesList" output="false">
   		<cfargument name="returnInfo" required="no" default="codes">
    	<cfquery name="getCounties" datasource="myresourcesimport" cachedwithin="#CreateTimeSpan(1, 0, 0, 0)#">
		Select * From temp_data_county
		Order By Countyname
		</cfquery>
		<cfset Counties = "">
		<cfoutput>
			<cfloop query="getCounties">
				<cfswitch expression="#arguments.returnInfo#">
					<cfcase value="codes">
						<cfset Counties = listappend(Counties,getCounties.Countycode,"^")>
					</cfcase>
					<cfcase value="names">
						<cfset Counties = listappend(Counties,"#getCounties.Countyname# (#getCounties.Countycode#)","^")>
					</cfcase>
				</cfswitch>						
			</cfloop>
		</cfoutput>
    	<cfreturn Counties />
	</cffunction>