[ic] Canīt use a db - table/ just products
Stefan Hornburg Racke
interchange-users@interchange.redhat.com
Sat Nov 24 12:53:00 2001
"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)