[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] Canīt use a db - table/ just products
"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)
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users