Forum OpenACS Q&A: Re: error to note-add.tcl - Newbie question

Collapse
Posted by Claudio Pasolini on
Yves,

user information is actually spread on several tables, i.e. parties, persons and users and the column first_names is on persons table, not on users.

You could use the cc_users view wich joins all the necessary tables or simply check the columns in the various tables using the psql command \d table_name (if you are using PostgreSQL) or the sqlplus command descr table_name (if Oracle).