[ic] Can´t use a db - table/ just products

[Stefan Hornburg Racke]

"Florian Schuler" <VisionCall@gmx.de> writes:

> Hello list,
> 
> I have problems to do a sql statement with other tables  than products !!
> I´m usinng IC 4.8.2, Postgres 7.1
> The table I want to use, is called "servicesupport"
> 
> I created the file servicesupport.pgsql" in my dbconf/pgsql/. see at the end
> of this E-Mail
> In my catalog.cfg I added servicesupport to "ProductFiles  products
> servicesupport"
> 
> Then I resarted (like 1001 times before) IC.
> Now, I do something like this:
> 
> [query st=db list=1 sql="select * from servicesupport where artikelnr=2"]
> This is my FAX number:[sql-field fax] (for example)
> [/query]

Hm, does:

[query st=db table=servicesupportlist=1 sql="select * from servicesupport where artikelnr=2"]
...
[/query]

work ?

Ciao
      Racke

-- 
Die Erde bleibt keine Scheibe. --- The earth remains no disk.

For projects and other business stuff please refer to COBOLT NetServices
(URL: http://www.cobolt.net; Email: info@cobolt.net; Phone: 0041-1-3884400)