Hmm. Still trouble. It seems that even after I did a qyery:
UPDATE page SET author='5' where author='18'
there are still a lot of fields that have author=18.
Why can this be??????? I'm realy shocked. I can only find those fields when
I do a query like this:
Select * from page where up='41'
I get a lot of pages with author = 18. These do not show up if I do:
select * from page where author='18'
WHY???
I'm in deap shit here, does anyone know what is wrong?
Tarjei
> On Monday 20 August 2001 21:01, you wrote:
>> Hi, I deleted a user from my midgard person table, and I need to
>> change all referenses to the person as an author in other tables. I
>> whant to do that using sql querys. Does anyone know how?
>>
>> what I need is something like
>>
>> UPDATE article.author FROM article WHERE article.id =!'person.id' or
>> something like that.
>
> UPDATE article SET author=newauthorid WHERE author=deletedauthorid.
>
> A quick way to find orphaned articles:
>
> SELECT article.id,article.author FROM article LEFT JOIN person ON
> article.author=person.id WHERE person.id is NULL
>
> Emile
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
____________________
Tarjei Huse
920 63 413
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
