Forum OpenACS Q&A: Re: Documentation cleanup suggestion.

Collapse
Posted by Jade Rubick on
Hi Joel,

When you get around to it, here is another suggestion:

The samplenote add-edit page looks like this:

<?xml version="1.0"?>
<queryset>
  <fullquery name="do_insert">
    <querytext>
        select samplenote__new(null,:title, :body,null,:user_id,null,null)
    </querytext>
  </fullquery>
  <fullquery name="do_update">
    <querytext>
      update samplenote
          set title = :title,
              body = :body
        where note_id = :note_id
    </querytext>
  </fullquery>
  <fullquery name="note_query">
    <querytext>
      select title,
            body
        from samplenote
      where note_id = :note_id
    </querytext>
  </fullquery>
</queryset>

That first null should actually be the key that is passed in, I think it should be :note_id. You can see this thread for more details of how I came to discover this: https://openacs.org/forums/message-view?message_id=91910