Forum OpenACS Q&A: why the users intrests dont show up on the Home page.

Is the users intrests ported to openacs. If the categories are
functional and the same does not figure out on the users homepage.

The commented out code is as follows

<p>
#  set selection [ns_db select $db "select
#    c.category,
#    c.category_id,
#    decode(ui.category_id,NULL,NULL,'t') as selected_p
#  from categories c, (select *
#                      from users_interests
#                      where user_id = $user_id
#                      and interest_level > 0) ui
#  where c.enabled_p = 't'
#  and c.category_id = ui.category_id(+)"]

#  set interest_items ""
#  while { [ns_db getrow $db $selection] } {
#      set_variables_after_query
#      if { $selected_p == "t" } {
#      append interest_items "<input name=category_id type=checkbox
value="$category_id" CHECKED> $category<br>
"
#      } else {
#      append interest_items "<input name=category_id type=checkbox
value="$category_id"> $category<br>
"
#      }
#  }

#  if ![empty_string_p $interest_items] {
#      ns_write "
#  <#h3>Your Interests (According to Us)</h3>

#  <#form method=POST action="interests-update.tcl">
#  <#blockquote>
#  $#interest_items
#  <#br>
#  <#br>
#  <#input type=submit value="Update Interests">
#  <#/blockquote>
#  <#/form>
#  "
#  }

That doesn't look terribly hard to rewrite as a legal Postgres query,
I'll take a look at it sometime in the next few days.

It may be that no one bothered to translate it because the feature
wasn't really implemented in the equivalent ACS Classic version, so
that's one thing I'd check first.  aD has a history of issuing
releases with incomplete snippets of not-fully-implemented features,
which in some cases were just ignored in the porting effort.

But then again this might've just been an oversight by whoever ported
this particular page, probably me...