On Tue, 09 Dec 2003 13:24:03 -0500, Michael Stassen
<[EMAIL PROTECTED]> wrote:
>
>You don't want to filter the quotes from the input string, because they
>exist in the data. (Well, you could filter from both sides, but that's
>inefficient.) What you need to do is escape the quotes with backsla
Three messages quoted, with my responses interspersed:
zzapper wrote:
[8 Dec 2003 19:07:49 -]
Hi Ya,
I have a typical select as follows
SELECT * FROM ytbl_development AS t1
WHERE (t1.txtDevName LIKE '%#form.searchtext#%')
However users a complaining that if they search for for a nam
Hi Ya.
I seem to have solved my problem if I clean out any punctuation from
my search string (see below (ColdFusion script))
When I perform the WHERE LHS-Containing-Quote LIKE RHS-without-quotes
The LIKE appears to ignore the quotes (which is what I want)
BUT IS THAT A FEATURE OF LIKE???
zz
On Mon, 08 Dec 2003 19:07:43 +, zzapper <[EMAIL PROTECTED]> wrote:
>Hi Ya,
>I have a typical select as follows
>
> SELECT * FROM ytbl_development AS t1
> WHERE (t1.txtDevName LIKE '%#form.searchtext#%')
>B)
>Now I can filter any quotes from form.searchtext easy enough, but how
>do I f
Hi Ya,
I have a typical select as follows
SELECT * FROM ytbl_development AS t1
WHERE (t1.txtDevName LIKE '%#form.searchtext#%')
However users a complaining that if they search for for a name that
contains a quote eg a development named King's Reach it is not found.
A)
Now it simply won
