...WHERE Table.French = '#ReplaceList(french, "�,�", "c,e")#'
At 11:36 AM -0400 6/15/01, Jason Blum wrote:
>Howdy all!
>
>I have a simple query question:
>
>Suppose you have this table:
>
>french | english
>R�p�tez | repeat
>fran�ais | french
>
>And you want people to be able to type in a French word, and received the
>English translation.
>
>But you can't assume they can type in characters like � or �
>So whether they type in R�p�tez or Repetez, you want to return "repeat"
>
>So I need to use something like
><cfset FrenchWithoutAccents = "#ReplaceList(french, "�,�", "c,e")#">
>
>But how do I incorporate that into the query?
>
>Thanks in advance!
>-J
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
