Hi everybody, I use microsoft SQL server, and XSP pages. I also use ESQL for all my DB commands.
I want to insert data with query like "INSERT Into blabla (ID) values (MyArray)" In this query "MyArray" is the result of another query. How can I make it? Here is an example : Table : XY Columns : ID, Num, Date, Descript Table : blabla Columns : ID, Num_ID, Num_text First I select some entries from table XY : Select * >From xy Where Descript LIKE '%abc' Then I want to put them into an array (oARRAY) and make a query to insert entries with these paramters. INSERT INTO blabla (Num_ID, Num_text) VALUES (oARRAY[1], 'abc') INSERT INTO blabla (Num_ID, Num_text) VALUES (oARRAY[2], 'abc') ... Or do someone have another solution? Thanks a lot for your help! --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>