Is there an elegant way to access an SQL database from YACS?

Boen, Jan -- on Aug. 18 2006

We have an SQL database that has been in use for quit a while but it has been running with a dedicated front-end. We would like to integrate this into a YACS environment.

Any guidelines/suggestions how we can do this and also benefit from the YACS skin and related features?

Thanks

Jan

Bernard from nearby-an-airport Associate, 6696 posts	on Aug. 21 2006 Jan, Can you convert data to MySQL format?
Jan B 85 posts	inspired from Bernard on Aug. 21 2006 Bernard: The database is already a MySQL database. Should have mentioned that in the first posting
Bernard from nearby-an-airport Associate, 6696 posts	inspired from Jan B on Aug. 22 2006 Jan B : Ok, then the next step would be to put every table within the same database. You can adjust table prefixes to avoid name collisions. Then, ultimately, you will be able to apply any SQL SELECT statement within any article to have YACS build nice tables on screens...

3 comments

Rate this page
Posted by Jan B on Aug. 18 2006, commented by Bernard on Aug. 18 2006, (popular)