Escapestring not escaping ^

jda jda at his.com
Tue Nov 1 16:48:34 CST 2005


>  > I looked in the RB docs and didn't see any info on this...is there
>>  any? I mean, docs that tell use the features of the LIKE search that
>>  Valentina supports?
>
>Valentina SQL.pdf
>

Hi Ruslan,

Wow, there's not much info there, is there?

OK, I'll have to experiment. I have noticed that you cannot do this 
search with LIKE:

'%%%' //trying to find %

But it works if escaped:

'%\%%'

You mentioned before that LIKE searches don't need escaping (other 
than ', I guess) but obviously they do.

Can you (or Ivan) please tell me what other characters need to be 
escaped for LIKE searches? (I'll do it manually, since you think 
escapeString shouldn't do very much).

Thanks,

Jon


More information about the Valentina-beta mailing list