Removed the trailing semicolon and it works. (perplexed look on my
face).
On Thursday, December 30, 2004, at 10:09 AM, Bill Conlon wrote:
This one is driving me nuts. I have DirectDBMS query that I have
validate using the mysql command line:
mysql> SELECT documents.id, documents.title, documents.description,
documents.topics_id, documents.public, documents.date,
documents.status, documents.owner_id, documents.template_id,
templates.name, media.mime_type_id
-> FROM templates, documents LEFT JOIN media_uses ON
media_uses.type_id=documents.id
-> LEFT JOIN media_description ON
media_description.id=media_uses.media_description_id
-> LEFT JOIN media ON media.id=media_description.media_id
-> WHERE (documents.org_id=413) AND
-> documents.template_id = templates.id
-> ORDER BY documents.id ASC;
<snip>
17 rows in set (0.01 sec)
mysql>
But, when I run this in Witango I get an error:
1064. [MySQL][ODBC 3.51 Driver][mysqld-3.23.58]You have an error in
your SQL syntax near ';
' at line 7
-101. General error during data source operation.
-101. General error during data source operation.
Any ideas??
_______________________________________________________________________
_
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
