Skip navigation
rabbit78
Currently Being Moderated

flex 4.6 sqlite  Multiple insert from list...

Dec 30, 2012 2:24 AM

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!!!!

 

 

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points