[flexcoders] air sqlite image loading

[sudha_bsb]

Hi,

I am trying to store an image into Sqlite database from an air
application and also trying to display the image by reading data from
the database. I am using blob datatype for this. I am getting the
following error while doing it...

Error #2044: Unhandled IOErrorEvent:. text=Error #2124: Loaded file is
an unknown type.

This is what i am doing while loading the image from
database...resultData is the array result from database

                            var imgData:String = resultData[i].image;
                            trace('imgData'+imgData);
                            var decoder:Base64Decoder = new
Base64Decoder();
                            decoder.decode(imgData);
                            var byteArr:ByteArray = decoder.toByteArray();
                            trace('bytearr'+byteArr);
                            var img:Image = new Image();
                            img.load(byteArr);
                            obj.image = img
                            personData.push(obj);

Similary while inserting the data...

var byteArr:ByteArray = new ByteArray();
                byteArr.writeObject(person.image);
                var encoder:Base64Encoder = new Base64Encoder();
                encoder.encodeBytes(byteArr);
                var encoded:String = encoder.toString()
                trace('encoder string'+encoded);
                var sqlInsert:String = "insert into Person
values('"+person.name+"','"+person.email+"','"+encoded+"');";
               
Please help....

Thanks & Regards,
Sudha.