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

Reply via email to