Forum OpenACS Development: Re: How to retrieve data using quries written in Xql with TCL and ADP

read this tutorial: https://openacs.org/doc/openacs-4-6-2/tutorial.html

basicly you need to use in the .tcl
db_*  for your queries.
search on your /api-doc (or in https://openacs.org/api-doc/) for the available procs.

and then in you .adp
in the case of a multirow you will want to use the tag <multiple> from the templating system: https://openacs.org/doc/acs-templating/tagref/multiple.html