[PATCH] SQLite escape single quote

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[PATCH] SQLite escape single quote

Pedro Aguilar
Hi,
 
This patch adds a function that escapes only single quotes by putting two single quotes in a row as SQLite likes them, otherwise it gives an insert error.
 
Reference:
http://www.sqlite.org/lang_expr.html
in the section Literal Values
 
Regards,
 
Pedro Aguilar
http://paguilar.org

_______________________________________________
gnokii-users mailing list
[hidden email]
https://lists.nongnu.org/mailman/listinfo/gnokii-users

sqlite_escape_single_quote.patch (1K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [PATCH] SQLite escape single quote

Jan Derfinak
Hello Pedro.

The both patches look good, I will apply them.
Thanks.

Jan


On Tue, 20 May 2014, Pedro Aguilar wrote:

> Hi,
>  
> This patch adds a function that escapes only single quotes by putting two
> single quotes in a row as SQLite likes them, otherwise it gives an insert
> error.
>  
> Reference:
> http://www.sqlite.org/lang_expr.html
> in the section Literal Values
>  
> Regards,
>  
> Pedro Aguilar
> http://paguilar.org
>
>
--
_______________________________________________
gnokii-users mailing list
[hidden email]
https://lists.nongnu.org/mailman/listinfo/gnokii-users