You can also convert: ATTACH DATABASE x AS y KEY z to: SELECT sqlite_attach(x, y, z) where the parameters can be turned into bind arguments. Then embedded quotes won't be an issue.
-scott On Sun, Feb 20, 2011 at 11:31 AM, Pavel Ivanov <paiva...@gmail.com> wrote: > I believe doubling the single quote inside the string literal should help. > > > Pavel > > On Sun, Feb 20, 2011 at 2:23 PM, Sam Carleton > <scarle...@miltonstreet.com> wrote: >> This is a bit crazy and I know the ideal way would be to not allow the >> apostrophy in the first place but, my focus is easy of use for my customers, >> as compared to easy for me... >> >> I had a customer that saved their SQLite database here: >> >> D:/My Events/President's Day/event.sqlite >> >> My software uses ATTACH to connect to the DB: >> >> ATTACH DATABASE 'D:/My Events/President's Day/event.sqlite' AS EventDB; >> >> Obviously this isn't working. Is there some way to escape the apostrophe? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users