Re: update select queries

Derick Rethans schrieb:
> On Mon, 2 Oct 2006, Daniel Kipp wrote:
>
>   
>> The first words in the docs about your ezcQueryUpdate is:
>>
>> "Class to create select database independent UPDATE queries.
>> ezcQueryUpdate does not support updating from via a select call."
>>
>> Are there plans to change this soon too allow update select queries?
>>     
>
> I have to admit that I'm not fully sure what you mean here. In order to 
> remove all confusion, could you please present an example?
>
> regards,
> Derick
>   
I've must been really confused cause I wrote something different than I 
was looking for  soory
I meant and Insert Select Query like this one:

INSERT INTO
    test_01(`lft`, `rgt`, `name`)
SELECT
    `rgt`-2, `rgt`-1, 'text'
FROM
     test_01
WHERE
     test_01.id = 1

But it's the same in your docs it says on:
http://ez.no/doc/components/view/trunk/(file)/Database/ezcQueryInsert.html
"Class to create select database independent INSERT queries".
This means to me that something like the above is not possible - I hope 
I'm wrong

Daniel