Forum OpenACS Development: Response to A query writing tool.

Collapse
Posted by Tom Jackson on

I have redone the query writing proc. Now you can call a function by setting the querytext (in the .xql file) to:

   select [qd_write_query_select pb_acs_pkg__new 
     package_name => :package_name 
     owner_id => :user_id 
     context_id => :user_id ]

In this case the qd_write_query_select procedure returns:

pb_acs_pkg__new(null,
:package_name,
null,
null,
:user_id,
'pb_acs_pkg',
now(),
null,
null,
:user_id);  

Any comments would be helpful. The select beginning the querytext seems to be necessary to get the query dispatcher to work correctly.