Re: [BioMart Users] SQL syntax Error during query execution

2011-09-28 Thread nndegwa
Hi Syed, Thanks for your reply: Here is where you can fire the query to: http://reactomedev.oicr.on.ca/cgi-bin/mart And the canned query you want to try is "All modified proteins in a pathway". The other canned queries are working fine. Let me know if you need further details. In the meantime, I wi

Re: [BioMart Users] SQL syntax Error during query execution

2011-09-28 Thread Syed Haider
Hi Nelson, not sure which server to post this query to. I tried reactome.org: but no luck. I guess the second dataset isnt there. Anyhow, could you please do some detective work and start adding attributes of second dataset one by one and see which one causes it fail. Otherwise, let me have

Re: [BioMart Users] SQL syntax Error during query execution

2011-09-27 Thread nndegwa
Hi Syed, Here is the XML equivalent of the query that works: http://pastebin.com/gcNrKnM8 Thanks, Nelson > Sorry Nelson, i might have missed few details, but could you send me the > XML equivalent of the query ? > > > On 27/09/2011 15:20, nnde...@ebi.ac.uk wrote: >> Hi Junjun& Syed, >> I still

Re: [BioMart Users] SQL syntax Error during query execution

2011-09-27 Thread Syed Haider
Sorry Nelson, i might have missed few details, but could you send me the XML equivalent of the query ? On 27/09/2011 15:20, nnde...@ebi.ac.uk wrote: Hi Junjun& Syed, I still have problems with this earlier reported query. So I have tried to tweak a few parameters (listed below) as I generated

Re: [BioMart Users] SQL syntax Error during query execution

2011-09-27 Thread nndegwa
Hi Junjun & Syed, I still have problems with this earlier reported query. So I have tried to tweak a few parameters (listed below) as I generated error logs, hopefully these will be more useful to diagnosing the problem. You correctly pointed out the query involves a join between two datasets link

Re: [BioMart Users] SQL syntax Error during query execution

2011-09-26 Thread nndegwa
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, nnde...@ebi.ac.uk wrote: >> Hi, >> I am getting an error from one of my queries along t

Re: [BioMart Users] SQL syntax Error during query execution

2011-09-26 Thread Junjun Zhang
This SQL doesn't look correct, something is missing right before the 'AND' for the part that is joined with 'OR', with the exception of the last item as below: ((pathway__referencepeptidesequence__dm.referencedatabase_uniprot = 'P49327') AND (pathway__referencednasequence__dm.referencedatabase_ens

Re: [BioMart Users] SQL syntax Error during query execution

2011-09-26 Thread Syed Haider
Hi Nelson, how do you compile this query from the interface/web service ? Best, Syed On 26/09/2011 14:47, nnde...@ebi.ac.uk 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.con

[BioMart Users] SQL syntax Error during query execution

2011-09-26 Thread nndegwa
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, Nelso