search

amankumar12602 / anywhereindb

Automatically exported from code.google.com/p/anywhereindb
0 stars 0 forks source link

Non-standard quotes #7

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
The query builds the search string with double-quotes. If the server is running 
with ansi_quotes in the SQL mode, this will result in an error. Use single 
quotes instead:

$search_sql .= '`'.$collum[$j]['Field'] .'` like "%'.$search_text.'%" ';

should be

$search_sql .= '`'.$collum[$j]['Field'] .'` like \'%'.$search_text.'%\' ';

Original issue reported on code.google.com by sno...@gmail.com on 2 Oct 2010 at 2:09

GoogleCodeExporter commented 8 years ago 
Fixed!

Original comment by happ...@gmail.com on 22 Dec 2010 at 4:49