08 Sep

Livelink Database – List full path of nodes under a given Livelink Node

Posted by Hussain, under Database, Livelink

Recently I was working on some SQL for a client who wanted to list the full path information for all items under a given Livelink node. As the customer was using SQL Server rather than Oracle I could not use the Connect By functionality. To begin with I tweaked an SQL Server function that Stephen Fisher had posted on the Knowledge Center which returns the full path, seperated by colon’s, to a given Livelink Node, a new version of the SQL is shown below : Continue reading...

No Comments | Tags: , , , ,
08 Sep

Connect to a MySQL database

Posted by Hussain, under Database, MySQL, PHP

To connect to a MySQL database to make the data from the database available in your Web application, you can do two things:
1. create a connect.php page, and ‘include’ this page in the PHP page(s) where you need the connection to the database. Continue reading...

No Comments | Tags: , , , ,