[ic] SQL as products database

Mike Heins mikeh@minivend.com
Tue, 10 Apr 2001 11:56:44 -0400


Quoting tamas.kohegyi@unforgettable.com (tamas.kohegyi@unforgettable.com):
> Hi,
> 
> 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
that.

-- 
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.7621 fax 7501 <mheins@redhat.com>

For a successful technology, reality must take precedence over public
relations, for Nature cannot be fooled. -- Dick Feynman