Forum OpenACS Development: Re: querying table "users"

Collapse
Posted by Robert Locke on
Is this meant for OACS 3.x?  Or 4.x?  If the latter, then you should really read the developer's guide and other documentation (especially acs-templating) located in /doc/.  Otherwise, there are several problems with the code:

* the "users" table doesn't have all those fields.  try "cc_users" instead.

* your first <tr bgcolor=... is missing a closing ">" tag.

* all your <tr>'s are missing corresponding </tr>'s.

* it's set_variables_after_query not set_variable_after_query. (you're missing an "s")

I recommend you read the docs, study your error log, debug, etc when you encounter these types of problems.  Best of luck...

Collapse
Posted by Oscar Bonilla on
Also, did OpenACS 3.x include the db API? It would be much simpler to use the db API than using ns_db directly.