You want to look at parameters, in particular the sqlite3_bind_* funcs. basically:
sqlite3_prepare(..., "insert into foo values(?);", -1, &stmt, ...); sqlite3_bind_blob(stmt, 1, "bar", 3, SQLITE_TRANSIENT); sqlite3_step(stmt); On Sun, 16 Jan 2005 00:14:21 -0500, John Richard Moser <[EMAIL PROTECTED]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > ok, screw it, I'm storing configuration files, policies, and POSIX ACLs, > I'll figure out blobbing later; I've only mastered like 3 functions from > SQLite's C API, so I've got other things to worry about. For now, > base64 . . . > > John Richard Moser wrote: > > The documentation at [1] is confusing me. Does anyone have a URI or > > such where I could see examples of code to set and read BLOB data? > > > > I feel I may be looking at this as too simple a task. . . > > > > [1] http://sqlite.org/capi3ref.html > > > > - -- > All content of all messages exchanged herein are left in the > Public Domain, unless otherwise explicitly stated. > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.0 (GNU/Linux) > Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org > > iD8DBQFB6fgthDd4aOud5P8RAtHaAJ0c8nfvNxkhy1t7Hva5lax9KqZKqgCfRhvq > 8R+DtMBTA3dqE+g+sZeHWgo= > =l0zy > -----END PGP SIGNATURE----- > -- Cory Nelson http://www.int64.org