I am creating a Mobile APP in Flex/Adobe AIR. I am using SQLite to store and retrieve data. I have a situation where I need to INSERT an unknown number of rows into a table. Is there a way to do this with a single statement in SQLite? I know that it can be done using a loop in AS3, but wanted to see if it's possible with a single SQL statement. I have found references to using UNIONS and SELECT, however, the examples weren't completely clear nor was I sure that they were applicable to my situation. Any examples are certainly appreciated.
Thanks.