On Saturday 22 April 2006 11:38, johnf wrote:
> On Saturday 22 April 2006 11:01, Jon Foster wrote:
> > Using TMySQL40Connection I tried to use the following query:
> >
> > SQLQuery1.sql.text:='SELECT organizations.name as org,
> > tests.name as test '+
> > 'FROM tests INNER JOIN organizations '+
> > 'ON tests.organization=organizations.id '+
> > 'WHERE result<>''PASS'' '+
> > 'ORDER BY tests.name';
> >
> > When I try "open" the query I received an error indicating that I had an
> > error "near INNER JOIN ...". If I paste the query into the MySQL client
> > it works. I also removed the word "inner" and tried it but received the
> > same message except that it pointed to "join" instead of "inner".
> > Rewriting the query like below it worked:
> >
> > SQLQuery1.sql.text:='SELECT organizations.name as org,
> > tests.name as test '+
> > 'FROM tests, organizations '+
> > 'WHERE tests.organization=organizations.id AND
> > result<>''PASS'' '+
> > 'ORDER BY tests.name';
> >
> > Is there some filtering of the SQL that might be corrupting my query?
>
> Try using
> sqlquery1.TEXT:='SELECT organizations.name as org,
> tests.name as test FROM tests, organizations WHERE
> tests.organization=organizations.id AND result<>' + Quotedstr('PASS') +
> 'ORDER BY tests.name';
> Is 'result' in only one of the tables?
> John
I thought about this a little more. I don't know much about MySQL but does it
have a log. Check the log and see what your program is passing.
John
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
