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

Collapse
1: How to retrieve data using quries written in Xql with TCL and ADP
Posted by VenuMadhav Deevi on 05/16/03 07:30 AM
Hi,
  I had written all my select quries in .Xql file. It contains quries for retrieving onerow and multirows. Now i want to use .Tcl files to retrieve them and want display them using .Adp,
if any body can provide me sample for this i would be very thankful.

  .Tcl should have commands or statements to fetch single row i.e onerow and multrow and to display them through .ADP files.

With Regards

VenuMadhav Deevi

Collapse
2: Re: How to retrieve data using quries written in Xql with TCL and ADP (response to 1)
Posted by Rocael Hernández Rizzardini on 05/16/03 04:57 PM
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