replace '·' to my_middot

"joonstar" <webforumsuser@macromedia.com> wrote in message news:gnqcq9$8uh$1@forums.macromedia.com...
>I like to replace '?' (&middot; - interpuct) which is retrieved from database.
>
> The value of myQuery.string of the attached code is '?'.
>
> The result of the attaced code is '?' although I expect 'my_middot'
>
> How can I replace '?' to 'my_middot'?
>
>
> <cfquery datasource='db1' name='myQuery'>
> select string
> from myTable
> where id=1
> </cfquery>
> <cfoutput>
> #replace(myQuery.string,'?','my_middot')#
> </cfoutput>
>

Try this:

#Replace(myQuery.string,'?','&middot;','ALL')#

--
Ken Ford
Adobe Community Expert - Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
Fordwebs, LLC
http://www.fordwebs.com
http://www.cfnoob.com

What actually happens when you run that code?