Re: [gnome-db] INSERT statement with binary data



On Tue, 2009-01-20 at 16:13 +0100, Vivien Malerba wrote:
> As a side remark: creating a SQL string containing values literals is
> not
> the way to go: use variables instead which have the double benefit of
> making
> statement execution faster (the statement is parsed only once) and
> prevents
> SQL injection problems. Please see
> http://library.gnome.org/devel/libgda/unstable/GdaSqlParser.html#GdaSqlParser.descriptionand
> http://library.gnome.org/devel/libgda/unstable/main_example.html for
> some
> code example.

Johannes, maybe this is a general way to avoid some of backend-specific
SQL generation in Glom, for all field types. That would be great.

-- 
Murray Cumming
murrayc murrayc com
www.murrayc.com
www.openismus.com




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]