[ic] SQL as products database
Tue, 10 Apr 2001 11:56:44 -0400
Quoting firstname.lastname@example.org (email@example.com):
> On Tuesday 10 April 2001 12:35, you wrote:
> > I have -
> > Database products products.txt dbi:Pg:dbname=test
> > in the catalog.cfg
> > How I can get information from the database now?
> > I've tried to use [loop] and [query sql="select * from products"] - it
> > does not work!
> Do not use * in your query. Try to use "select this,that from products"
> See the minivend 3.x documentation/tag reference [sql ...] tags for examples.
It is perfectly fine to use *.
You can reference any field with [sql-param fieldname] if you do
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <firstname.lastname@example.org>
For a successful technology, reality must take precedence over public
relations, for Nature cannot be fooled. -- Dick Feynman