Click here to Skip to main content
15,894,343 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi,
i m wondering to upload file from flex to sqlite database and again need to retrieve from database to flex.can anyone help me how to do this?
Posted

There are several good articles and tutorials to be found: try searching the easy way[^]

I also recommend to by a book, that topic will be covered in nearly all books.
 
Share this answer
 
C#
<fx:Script>
        <![CDATA[
import flash.filesystem.File;
            import flash.system.Capabilities;
            import flash.utils.ByteArray;
import mx.utils.Base64Decoder;
            import mx.utils.Base64Encoder;

public var fnamearr:Array=new Array();
            private var loadedFile:ByteArray;
            public var byte:String;
            public var bytesarr:Array=new Array();
            public var p:int;

/*browse button function*/

public function browse_file(eve:MouseEvent):void{
                file1 = File.documentsDirectory;
                file1.addEventListener(Event.SELECT, handleSelectFile);
                file1.browseForOpen("Select Picture");

            }
            public function handleSelectFile(event:Event):void
            {
                if(os=="Win" ){
                    file_name.text = event.target.nativePath;
                }
                else if(os=="Mac"|| os=="Lin"){
                    file_name.text = event.target.url;
                }
                fnamearr.push(event.target.name);
                Alert.show(event.target.name);
                var request:URLRequest = new URLRequest(file_name.text);
                var urlLoader:URLLoader = new URLLoader(request);
                urlLoader.addEventListener(Event.COMPLETE,onURLLoaderComplete);
                urlLoader.dataFormat = URLLoaderDataFormat.BINARY;
                urlLoader.load(request);
            }

            private function onURLLoaderComplete(event:Event):void
            {
                loadedFile = event.target.data;
                var encoder:Base64Encoder=new Base64Encoder();
                encoder.encodeBytes(loadedFile);
                byte=encoder.toString();
                bytesarr.push(byte);
                //byte=encoder.encode(loadedFile);
                Alert.show('==>'+file_name.text);

            }
/*finally store bytesarr (array),fnamearr(filename array) into sqlite database*/


// save in sqlite database
public function saveLoadedFile():void
            {

                for(var j:int=0;j<bytesarr.length;j++){
                    if(bytesarr[j].length!=0 && bytesarr[j]!='' ){
                        dbStatement=new SQLStatement();
                        dbStatement.sqlConnection=exampleDB;
                        dbStatement.text="INSERT INTO cmr_patient_files (patient_id,file,filename) VALUES (:recordId,:byteArray,:recordNote)";
                        dbStatement.parameters[":recordNote"] = fnamearr[j];
                        dbStatement.parameters[":byteArray"] = bytesarr[j];
                        dbStatement.parameters[":recordId"] = spat_id;
                        dbStatement.execute();
                    }
                }}
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900