[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
RE: [ic] SQL as products database
Apr 10, 13:07 +0100, Jonathan Clark has written:
> This is now your problem. Interchange will not be able to see your tables
> unless you tell it which ones to bind to. It will then do a 'select * from
> <table> limit 1' to work out the field names and make them available. You
> can specify the data types in the products.pgsql file or it will assume
> varchar(255) (I think).
>
> you need something like:
--- scip ---
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 :(( )
my best regards,
-----------------------------
Grigoriy G. Vovk
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users
