Error with MySQL Table Join

Article View: adobe.golive.windows

Article #37695

Back to adobe.golive.windows Previous Next

#37695

From: Julian Summers
Date: Fri, 10 May 2002 22:28

7 lines
1490 bytes

I have got a query that works fine in MySQL, but fails in GoLive 6. Table Queries and Custom SQL for a single table work fine, but I keep getting the following error on SQL with a table join using JSP & JDBC: 

javax.servlet.ServletException: wrapJDBCResultSet java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax near ' FROM datasource' at line 1 	at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source) 

I have read a few messages that mention selecting an 'ID' which I take to be the primary key. I have selected the primary keys of each table and with both. The error appears as though the datasource name is being passed to MySQL rather that the SQL query, but it might just be a dodgy error message. 

This is driving me mad, so I would be pleased with any advice.

Technical Details

Message-ID: <ef87669.-1@WebX.aaQKaf7vad4>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!telocity-west!TELOCITY!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!WebX

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101ba1,daa11345f2a1ce7a,start
X-Google-Attributes: gid101ba1,public
X-Google-ArrivalTime: 2002-05-10 15:37:31 PST
From: "Julian Summers" <julian.s@virgin.net>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!telocity-west!TELOCITY!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!WebX
Newsgroups: adobe.golive.windows
Subject: Error with MySQL Table Join
Message-ID: <ef87669.-1@WebX.aaQKaf7vad4>
Date: Fri, 10 May 2002 15:28:12 -0700
Lines: 16
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit