Hello, All.
I've got a trouble. My LinksSQL 2.0.4 is on Oracle8.1.7, and it doesn't repair my tables. I even know why: Oracle doesn't know such SQL words like LEFT OUTER JOIN, and function build_orphan_check use it!
Look at the error i've got:
GT::SQL::error = Failed to prepare query: '
SELECT wdLinks.Title, wdLinks.ID
FROM wdLinks LEFT OUTER JOIN wdCatLinks ON wdCatLinks.LinkID = wdLinks.ID
WHERE (wdCatLinks.LinkID IS NULL)
Instead of it, we should use, for example, the following SQL-operator in Oracle:
select title, id
from wdlinks
where not exists (select id from wdcatlinks where wdlinks.id = wdcatlinks.id)
but we cannot execute this operator with GT::SQL::Table...
Can you help us?
With respect,
Anton Permyakov
I've got a trouble. My LinksSQL 2.0.4 is on Oracle8.1.7, and it doesn't repair my tables. I even know why: Oracle doesn't know such SQL words like LEFT OUTER JOIN, and function build_orphan_check use it!
Look at the error i've got:
GT::SQL::error = Failed to prepare query: '
SELECT wdLinks.Title, wdLinks.ID
FROM wdLinks LEFT OUTER JOIN wdCatLinks ON wdCatLinks.LinkID = wdLinks.ID
WHERE (wdCatLinks.LinkID IS NULL)
Instead of it, we should use, for example, the following SQL-operator in Oracle:
select title, id
from wdlinks
where not exists (select id from wdcatlinks where wdlinks.id = wdcatlinks.id)
but we cannot execute this operator with GT::SQL::Table...
Can you help us?
With respect,
Anton Permyakov