Hi Syed, Yes, this query comes from a canned query sent via web service. Cheers, Nelson
> 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
