Escaping commas in Coldfusion generated url

I have a url that contains parameters based on the user's selection. In the title parameter a comma exists. This is causing the page to be displayed incorrectly. The url looks like:

http://mysite//coursereg.cfm?sortby=Course_Reg_Course_Title&filterby=Anchorage,%20Alaska%20Partnership%20Dialogue%20Series&direction=ASC


It should be

http://mysite//coursereg.cfm?sortby=Course_Reg_Course_Title&filterby=Anchorage,%20Alaska%20Partnership%20Dialogue%20Series&direction=ASC

to work properly

The Coldfusion code is

<cfparam name="sortby" default="Course_Reg_Created_On">
<cfif isDefined("url.sortby")>
      <cfset sortby = url.sortby>
</cfif>
<cfparam name="direction" default="DESC">
<cfif isDefined("url.direction")>
      <cfset direction = url.direction>
</cfif>
<cfparam name="filterby" default="All">
<cfif isDefined("url.filterby")>
      <cfset filter = url.filterby>
</cfif>
<cfparam name="titlesort" default="title ASC">

<cfquery datasource="#application.dsName#" username="#application.dsUserName#" password="#application.dsPassword#" name="courses1">
SELECT * FROM courses_regs
</cfquery>

<cfquery datasource="#application.dsName#" username="#application.dsUserName#" password="#application.dsPassword#" name="courses2">
SELECT Distinct Course_Reg_Course_Title FROM courses_regs
</cfquery>

<cfquery dbtype="query" name="courses">
SELECT * FROM courses1
<cfif listFindNoCase('#ValueList(courses2.Course_Reg_Course_Title,",")#', filterby)>
WHERE Course_Reg_Course_Title LIKE '%#filterby#%'
</cfif>
ORDER BY #sortby# #direction#
</cfquery>


Start Free Trial