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

Reply via email to