-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Jeremy Hinegardner wrote: > SELECT name, blob FROM blobs WHERE name = $name; > > And the driver, under the covers uses the blob IO routines to retrieve > the blob data from SQLite when the user accesses the result set.
To get the rowid it needs to be in the SELECT (eg SELECT rowid, name, blob ....) as you mentioned, although there have been other requests on the list to have some API to always get the rowid as you requested. In any event it is a bad idea to provide the blobs "transparently" because later SQL statements can make them go bad or have similar effects which would be unexpected to your user. Changeset 5313 documents how open blobs are affected, and you will want your users to explicitly request them as needed. http://sqlite.org/cvstrac/chngview?cn=5313 Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFIaEb2mOOfHg372QQRAtHmAJ96GjsG03Y2tEkQ3Iw4RD+6zQ6Z1ACgy6uA tqQTzAoWsxO3MQTgAsJNTew= =hY0M -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
