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


Thanks for your help. Anyway, I couldn't figure out how to construct
this query correctly from the examples as they seem to use methods from
gda-easy.c which are not available in the C++ bindings, yet
( If you could create
non-vararg versions it shouldn't be difficult.

Sorry, I cannot attach the full query because it's a single long line
and it broke any editor I tried.


Am Dienstag, den 20.01.2009, 16:13 +0100 schrieb Vivien Malerba:
> 2009/1/20 Johannes Schmid <jhs jsschmid de>
>         Hi!
>         I am trying to fix a bug in glom where it tries to insert
>         binary data (a
>         png image) using an INSERT statement. SqlParser reports that
>         the
>         statement is malformed but I couldn't figure out how to fix
>         that. The
>         statement is basically:
>         INSERT INTO "contacts" ("contact_id", "name_first",
>         "name_middle",
>         "name_last", "name_title", "address_street", "address_town",
>         "address_state", "address_country", "address_postcode",
>         "date_of_birth",
>         "comments", "name_full", "picture", "email", "website",
>         "tel_home",
>         "tel_work", "tel_mobile", "tel_fax") VALUES
>         (0,'Murray','','Cumming','Mr','Falschstrasse
>         123','Munich','Bavaria','Germany','D-80798','1973-05-11','','Murray
>         Cumming', '<no a lot of binary data follows>',
>         '','','','','','')
>         The binary data looks about like this: \\362\\377\\001NIU\\225
>         \\016\\376
>         \\034\\350\\000\\000\\000\\000IEND\\256B`\\202 (just an
>         example.
>         How does this data need to be encoded so that GdaSqlParser is
>         happy with
>         it?
> Can you send me the exact string you need to parse?
> 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
> and for some code example.
> Vivien
>         Thanks,
>         Johannes
>         _______________________________________________
>         gnome-db-list mailing list
>         gnome-db-list gnome org

Attachment: signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil

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