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't match King's Reach whether I include the quote or
not. WHY?? (Have the quotes been converted ie to URL Encoding))
B)
Now I can filter any quotes from form.searchtext easy enough, but how
do I filter them the Left Hand Side eg from txtDevName?)
I look forward to seeing how you solve this.
zzapper
--
vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?"
http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
