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]

Reply via email to