[Babase] ADM rnktype Query Changed in Babase
Lacey Maryott
lacey.maryott at duke.edu
Thu Oct 18 14:21:25 EDT 2007
Hello All,
As Per out conference call yesterday regarding the errors in rnktype
queries, I have now changed the query for rnktype ADM to the following
SELECT DISTINCT(biograph.sname) from biograph, members, rankdates where
biograph.sname = members.sname AND members.date >= %s AND members.date<=
%f AND members.grp= %g AND biograph.sex='M' and
rankdates.sname=biograph.sname and ranked <= %f;
This query replaces the old query which was:
SELECT DISTINCT biograph.sname FROM biograph, members WHERE
biograph.sname = members.sname AND members.grp = %g AND biograph.sex =
'M' AND members.date >= %s AND members.date <= %f AND
(%f-biograph.birth) >= 5
I have since run ranker using ADM rnktype and the correct group of
individuals is produced for Weaver's ADM Jan 2006. In our checking, it
seemed as though the ADF rnktype was correctly configured, but Tabby may
have more input on that.
This should resolve this one of the Ranker issues.
Cheers
Lacey
--
Lacey Maryott
Alberts Lab
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu
More information about the Babase
mailing list