Ronald J Kimball wrote:
>On Wed, Sep 04, 2002 at 02:27:23PM +0200, Roger Perttu wrote:
>
>
>>No, your suggestion won't work for me. I have absolutely no control of
>> the "query". Stored procedures with multiple or no result sets will be
>>common. If I chose to use eval it will be rather painful to use
>>sth->trace() because of all the noise DBI will print.
>>
>>
>
>If you have absolutely no control over the query, how do you know what
>you're supposed to do with the results anyway?
>
>
>
I store the result for later use in another query.
If this is the (pseudo) input to my program:
select ID from table1
select Name from table2 where PersonID = ID
insert into table3 values(ID, Name)
Then ID from query one and Name from query two will be inserted into
table3. Queries might be spread across different databases and nest to
any depth (until I run out of connections).
Does anyone know if such a tool already exists?
/Roger P
