single quote search error

[rajesh11]

We are searching the word containing single quotes like "it's php" but it give errors: /lfScript/searchService Line 1: syntax error at "s" 000 /lfScript/searchService SQLPrepare() failed with -1 in the function prepntexis

Please look into this matter

[John]

Use parameters, don't build the string. E.g.

<SQL "select Fields from Table where Field like $query"></SQL>

[mark]

http://www.thunderstone.com/site/vortexman/node33.html