That's it!!! Thank's anonymous! (Chris - that was you, wasn't it?)
Bill, I had thought of your suggestion, but hate to essentially duplicate a
column like that.
Thanks all!
-J
____________________Reply Separator____________________
Subject: Re: ## Simple query question
Author: [EMAIL PROTECTED]
Date: 6/15/01 9:04 AM
....WHERE Table.French = '#ReplaceList(french, "A,E", "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
>REpEtez | repeat
>franAais | 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 E or A
>So whether they type in REpEtez or Repetez, you want to return "repeat"
>
>So I need to use something like
><cfset FrenchWithoutAccents = "#ReplaceList(french, "A,E", "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
