3431 Posts in 1058 Topics by 734 members
|Go to End|
19 April 2013 at 3:09pm
I am making a query using sqlQuery in Silverstripe 3.1 . Now when i try to add an inner join using
$sqlQuery->addInnerJoin('Member', 'testTable.OwnerID = Member.ID');
the raw query i am getting with this is something like
INNER JOIN "Member" ON testTable.OwnerID = Member.ID,
which when executed in mysql gives syntax error,as there should be no double quotes in the table name,when i remove the quotes,it works.
But how can i resolve this in my code?
Thanks for any kind of help.
19 April 2013 at 4:40pm
The generated SQL is correct. SilverStripe runs MySQL in ANSI mode, which means that database, table and column names should be enclosed in double quotes (“) rather than the normal back ticks (`). If you are running the query in a mysql shell, or through something like PHPMyAdmin, you need to runfirst.
|Go to Top|