Date index for Feb 2004
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Svar: Re: [achievo] Achievo 1.0.3
so i should write this:
update person set entity=1 where entity=0 and role='employee'
but i didnt get this: "(if 1 is the correct entity)"
>>> ivo dot
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
Junaid Mukhtar wrote:
> +--------+
> | entity |
> +--------+
> | 0 |
> +--------+
Ok, then it's a remnant of your first installation. You should delete
the profile with id 0, and update all person records who are currently
set to 0, and set them to an entity other than 0:
update person set entity=1 where entity=0 and role='employee'
(if 1 is the correct entity)
Greetings,
Ivo
- --
Ivo Jansch <ivo dot
ibuildings.nl BV - information technology
http://www.ibuildings.nl
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFAJ6Pf95NUnGFZm9cRArntAKCcJWTNjcH79f9u150r9rj2cmwdIACgtINH
HCqHk4/FIgYNoov2cE0tuJU=
=sAIU
-----END PGP SIGNATURE-----
[ Achievo mailing list - http://www.achievo.org/ ]
[ to unsubscribe send an e-mail to achievo-unsubscribe dot