Now I am unfortunately stumble into another problem. An SQL Statement that worked with the ODBC-JDBC driver without an error throws up this with your HXTT jdbc driver:
Syntax error: Stopped parse at UNION(id56)
The SQL Query has to combine two queries into a single one as the criterias to certain data is different.
SELECT CatID, Titel,CatIDReferenz, Ebene, Reihenfolge, Parameterstring
FROM Cats
WHERE Sprache = 'en'
AND Titel <> NULL
AND Ebene = 2
AND CATIDReferenz = 15
AND Parameterstring <> NULL
AND Reihenfolge <> 0
ORDER BY Ebene, Reihenfolge
UNION
SELECT CatID, Titel,CatIDReferenz, Ebene, Reihenfolge, Parameterstring
FROM Cats
WHERE Sprache = 'en'
AND Titel <> NULL
AND Ebene = 2
AND CATIDReferenz = 15
AND Parameterstring <> NULL
AND CatID = #URL.page#
ORDER BY Ebene, Reihenfolge
I am trying to rewrite it but I have no clue. Thank you.
|
MS Access is not standard sql UNION sqyntax. You need to remove the first "ORDER BY Ebene, Reihenfolge "
SELECT CatID, Titel,CatIDReferenz, Ebene, Reihenfolge, Parameterstring
FROM Cats
WHERE Sprache = 'en'
AND Titel <> NULL
AND Ebene = 2
AND CATIDReferenz = 15
AND Parameterstring <> NULL
AND Reihenfolge <> 0
UNION
SELECT CatID, Titel,CatIDReferenz, Ebene, Reihenfolge, Parameterstring
FROM Cats
WHERE Sprache = 'en'
AND Titel <> NULL
AND Ebene = 2
AND CATIDReferenz = 15
AND Parameterstring <> NULL
AND CatID = #URL.page#
ORDER BY Ebene, Reihenfolge
|
|
You guys rock, thanks for the quick help!
|
Main
webmaster@hxtt.com