If you're trying to get all of the matching specficiation_id's, then maybe you want something like:
set myspecs [db list "SELECT specifications_id FROM product_specifications, products WHERE product_specifications.products_id = products.products_id"] On Tue, Mar 29, 2011 at 12:19 PM, Cyril Shtumf <webmas...@livehistory.ru>wrote: > Hello everyone! > > I was faced with an insurmountable problem when using the package DIO. The > problem is that the command "forall" returns only one row, if the body > contains the command "array". For example: > > db forall "SELECT `products_id` FROM `products`" row { > > db array "SELECT `specifications_id` FROM `products_specifications` > WHERE `products_id` = '$row(products_id)'" row2 > > } > > Alas, I don't know how to fix it. I hope for your help. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: rivet-dev-unsubscr...@tcl.apache.org > For additional commands, e-mail: rivet-dev-h...@tcl.apache.org > >