[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