[Babase] ADM rnktype Query Changed in Babase

Lacey Maryott lacey.maryott at duke.edu
Fri Oct 19 14:44:45 EDT 2007


change made in babase :)

L

Karl O. Pinc wrote:
>
> On 10/18/2007 01:21:25 PM, Lacey Maryott wrote:
>> 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;
>
> For good form we want to qualify each column name with a table
> name, so it should end with: rankdates.ranked <= %f
>
> Karl <kop at meme.com>
> Free Software:  "You don't pay back, you pay forward."
>                  -- Robert A. Heinlein
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase

-- 
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