Hi! 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 (http://bugzilla.gnome.org/show_bug.cgi?id=568484). 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. Regards, Johannes 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>', > '','www.murrayc.com','','','','') > > > 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 > http://library.gnome.org/devel/libgda/unstable/GdaSqlParser.html#GdaSqlParser.description and http://library.gnome.org/devel/libgda/unstable/main_example.html for some code example. > > Vivien > > > > Thanks, > Johannes > > > _______________________________________________ > gnome-db-list mailing list > gnome-db-list gnome org > http://mail.gnome.org/mailman/listinfo/gnome-db-list > >
Attachment:
signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil