[ic] SQL as products database

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

Quoting Jonathan Clark (jonc@webmaint.com):
> > Yes, I've done it, now I have dbconf/pgsql/products.pgsql,
> > and "#include dbconf/pgsql/*" in the catalog.cfg.
> > I use [sql type="list" sql="select * from products"]
> > (but, I didn't find information about 'type="list"' for tag [sql])
> > And my pages doesn't return any information.
> > Where can I get examples, description (other, then there are in
> > icdatabase.txt, iccattut.txt - for me it is not enough :(( )
> >
> Yes, I agree that the docs can be lacking, particularly recently some
> important information seems to have disappeared (I was looking for the [if]
> tag in the tagref and that has gone!) but remember what you payed for this
> world-class application ;-)
> I found this in the Minivend 3 docs (predecessor to Interchange):
> http://developer.akopia.com/minivend3/docindex/08.03.SQL_Access_Methods.html
> which is a description of the SQL tag.

Which doesn't exist anymore except as an alias for query.

[query list=1 sql="select * from products"]
	[sql-param description] [sql-param products]

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

"Even if you're on the right track, you'll get run over if you just
sit there." -- Will Rogers