2011-07-19, 05:45
qq_bryon Wrote:Actually found the solution to my problem by turning off escaped characters in mysql
http://stackoverflow.com/questions/30989...ated-query
bradvido88 Wrote:Yep that'll work but it shouldn't be necessary. I'll take a look at my escaping, I thought I had that handled correctly.
First of all, I'd just like to say thank you for developing this!
Just thought I'd add some info regarding the escaping of "\" characters in case it helps you troubleshoot - this seems to only be an issue when using mysql. On my dev box (win 7) everything was working fine against sqlite, it was only once I switched over to mysql (on win xp ) that the issue cropped up for me. I didn't bother providing a stacktrace, because it's essentially the same as what qq_byron included.
Not sure what your code looks like, but using a PreparedStatement might be a quick way to fix the issue as opposed to trying to escape the char.
In the meantime, I'm going to give the solution from stackoverflow in the url above a try.
Thanks again for a great tool