In InstantDB you have to escape quotes in strings using a backslash: \" or
\'. See types.html in your InstantDB docs for details.
Instant Computer Solutions
From: Kevin Yank <firstname.lastname@example.org>
To: email@example.com <firstname.lastname@example.org>
Date: 31 October 1999 16:21
>The following code is fairly basic:
> Statement statement = dbConnection.createStatement();
> String sqlQuery = "INSERT INTO Settings VALUES (\"UserName\", \"" + name
>However, if the String object "name" contains a double quote ("), the whole
>thing comes crashing down. I seem to recall there being a simple way around
>this... Some automatic means of escape-encoding a String before plugging it
>into an SQL statement, perhaps?
>I know that using a prepared statement would work, but I'd like to avoid
>this if possible in this case.
>To unsubscribe from this list, please an send
>email to 'email@example.com' with the text
>'unsubscribe instantdb' in the message body.
To unsubscribe from this list, please an send
email to 'firstname.lastname@example.org' with the text
'unsubscribe instantdb' in the message body.