Forum OpenACS Development: help with dotlrn


	The Toolkit for Online Communities 15939 Community Members, 0 members online, 2326 visitors today			Log In	Register

Forum OpenACS Development: help with dotlrn_communities table

OpenACS Home : Forums : OpenACS Development : help with dotlrn_communities table

Back to OpenACS Development

Icon of Envelope Request notifications

1: help with dotlrn_communities table

Posted by Philip Wang on 10/17/04 10:27 AM

hi, can anyone tell me how to see what values are stored in the table? (dotlrn_communities) i want to search for a community name (to get a community_id) and tried a search for pretty name, but says it's not in the table.

2: Re: help with dotlrn_communities table (response to 1)

Posted by Deds Castillo on 10/17/04 12:26 PM

What RDBMS are you using?

On oracle, you can use sqlplus and do "desc tablename". On postgres, you can use psql and do "\d tablename".

Of course you can use any other app that you are familiar with as long as it can display the schema. You may also want to check the sql directory of the dotlrn package to see how the table was created if in case you don't have access to those tools.

3: Re: help with dotlrn_communities table (response to 2)

Posted by Philip Wang on 10/17/04 12:51 PM

Thanks Deds, i'll try that out.

Back to OpenACS Development