[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] SQL as products database
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
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users
