0 Replies Latest reply: Dec 30, 2012 2:24 AM by rabbit78 RSS

    flex 4.6 sqlite  Multiple insert from list...

    rabbit78

      hi!!!

       

      i'm wirte this code:

       

      private function createNewPlaylist():void{

                                              var stat:SQLStatement = new SQLStatement();

                                              stat.sqlConnection = connection;

       

                                              stat.text = "INSERT INTO playlist (nome, base, testo, lista) value(@nome, @base, @testo, @lista)";

        stat.parameters["@nome"] = listaDatasong.selectedItem.nome;

                                              stat.parameters["@base"] = listaDatasong.selectedItem.base;

                                              stat.parameters["@testo"] = listaDatasong.selectedItem.testo;

                                              stat.parameters["@lista"] = listaCombo.selectedItem.combo;

                                              stat.execute(-1, new Responder(selectItemsPlaylist));

       

                                    }

       

      with this code i can insert a row at a time.....

       

      i want insert all select rows from "listaDatasong"....

       

      how to do???

       

      help me please!!!!