I don't have an example to hand, but from memory : Storing images is a question of reading the original image file as a bytearray and inserting that byteArray varaible into a blob field in the database. Reading is much the same, select the record and read/cast it into a byteArray. It's then possible to use Loader to convert that into an image (Some details on that @ http://ifeedme.com/blog/ ) Hope that's enough to get you going (it all worked fine for me) -----Original Message----- From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of sudha_bsb Sent: 20 July 2008 19:56 To: flexcoders@yahoogroups.com Subject: [flexcoders] air sqlite example with BLOB datatype Hi,
Can someone share a simple example on how to store and retrieve the BLOB data from SqLite using AIR. I want to store images in the database using BLOB type, retrieve them and show them as images. Please help, Thanks, Sudha. ______________________________________________________________________ This communication is from Primal Pictures Ltd., a company registered in England and Wales with registration No. 02622298 and registered office: 4th Floor, Tennyson House, 159-165 Great Portland Street, London, W1W 5PA, UK. VAT registration No. 648874577. This e-mail is confidential and may be privileged. It may be read, copied and used only by the intended recipient. If you have received it in error, please contact the sender immediately by return e-mail or by telephoning +44(0)20 7637 1010. Please then delete the e-mail and do not disclose its contents to any person. This email has been scanned for Primal Pictures by the MessageLabs Email Security System. ______________________________________________________________________