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 filter
Hi Ya.
I seem to have solved my problem if I clean out any punctuation from
my search string (see below (ColdFusion script))
cfset form.searchtext=replace(form.searchtext,'[[:punct:]]','','all')
When I perform the WHERE LHS-Containing-Quote LIKE RHS-without-quotes
The LIKE appears to ignore
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
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 backslashes
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