Passing Parameters with Single Quote

[bumblebee1965]

I am trying to pass this information to another cfm file. This works fine,
except when the name has a single quote (ie. Name = Katie's car). What is the
best way to handle this. Thanks in Advance. <a
href='test.cfm?name=#name#&amp;number=#number#'></a>

[bumblebee1965]

I am trying to pass this information to another cfm file. This works fine,
except when the name has a single quote (ie. Name = Katie's car). What is the
best way to handle this. Thanks in Advance. <a
href='test.cfm?name=#name#&amp;number=#number#'></a>

[JMGibson3]

HREF='somewhere.cfm&amp;prmName=#UrlEncodedFormat( Name)#'

then in somewhere.cfm
<cfset varName = UrlDecode(url.prmName)>

[tzimmerman]

Try using [url]http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b20.htm[/url] with a CFSQLType of CF_SQL_VARCHAR.

Ted Zimmerman