Hi Nelson, how do you compile this query from the interface/web service ?
Best, Syed On 26/09/2011 14:47, [email protected] wrote:
Hi, I am getting an error from one of my queries along the lines of SQL syntax being the cause, am not sure what the real problem is though. I set the log4perl.conf to debug mode and I got back a more elaborate error report http://pastebin.com/9rqKBfWR Anyone know what the problem is? Thanks, Nelson Serious Error: Error during query execution: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (pathway__referencednasequence__dm.referencedatabase_ensembl = 'ENSG00000166' at line 1 ERROR: caught BioMart::Exception::Database: Error during query execution: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (pathway__referencednasequence__dm.referencedatabase_ensembl = 'ENSG00000166' at line 1 _______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
_______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
