I found the problem with the thread and it only took two tries. my query was returning a value in angle brakcets in the script output window and when i enter the value in angle brackets in the thread it screws up the thread.

*******************************************************************
PLEASE DELETE multiple rows into one row and multiple rows into one row pt 2.
*******************************************************************

so here it goes again...

sorry to post a new thread but something happened to the other one and i can't reply to it.

On DaPi's advice i used a query like this...

select id,
cast ( multiset( select user_id
from caw_tabsaccess
where caw_tabsaccess.tab_id = caw_tabs.id and caw_tabsaccess.user_id IS NOT null
group by user_id ) as ONEDNUMBERARRAY ) USER_ID
from caw_tabs;

to get multiple rows into one.

the problem is it returns results like this

ID USER_ID
-- --------------
1 ONEDNUMBERARRAY()
2 ONEDNUMBERARRAY()
3 ONEDNUMBERARRAY()
4 ONEDNUMBERARRAY()
.
.
.

So how do i get the actual value back out of the ONEDNUMBERARRAY()?