Hi,
2010/6/16 Roger Binns <rog...@rogerbinns.com>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 06/16/2010 04:14 AM, Fabio Spadaro wrote:
> > But the next time I select a single line instead of two:
> > fetchall [(<read-write buffer ptr 0x0000000002CC2A68, size 1311 at
> > 0x0000000002CC2A30>,)]
> >
> > What's wrong.
>
> Errr, nothing. Blobs are returned as buffers too. (This way you can
> distinguish them from str.) Buffers act just like str. You can get an
> individual byte - buf[7] - or a range - buf[7:93] etc. You can convert
> them
> to str - str(buf).
>
> > Another question. If I wanted to convert the buffer to a file how should
> I
> > do?
>
> Just use it as is:
>
> open("filename", "wb").write(buf)
>
> Roger
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.10 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iEYEARECAAYFAkwZAVoACgkQmOOfHg372QTj4ACgwuDNdpMcFQEP901Sein+98Qy
> UaQAn1BwlSP1cN1xriY95XWekyg9sdjs
> =KSFO
> -----END PGP SIGNATURE-----
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
You can also determine the path and file name from the blob or should I
create a column attached with this information stored?
--
Fabio Spadaro
www.fabiospadaro.com
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
