[Babase] ranker again
Leah Gerber
lgerber at duke.edu
Mon Oct 9 09:11:15 EDT 2006
Hi Susan,
I was actually hoping Tabby would know a bit more than me. You are
correct I have never ACTUALLY used ranker. Just played with it a little
and then we entered ranks by hand. I also did not understand all of the
emails. If you feel that this is something you want me to devote some of
my last weeks to then I will. Maybe a conference call is in order
seeing as Tabby and I don't seem to understand what exactly is needed,
therefore don't know how to proceed.
Leah
kfenn wrote:
> Hi Susan,
>
> I'll go with whatever Leah says. I've worked with ranker exactly once
> and have never considered the rules behind it and am only
> understanding about 1/4 of these emails. If she thinks it's fine,
> then I'm sure I can learn whatever I need to learn, but I really don't
> know enough about this to give a real answer. Sorry!
>
>
> Tabby
>
> Karl O. Pinc wrote:
>>
>> On 10/06/2006 11:56:07 AM, Susan Alberts wrote:
>>> Karl, should you update the rnktypes table with the new types and
>>> remove FYM or can Leah/Tabby do this at this point? I think that you
>>> need to update the definition queries? I am not sure what these are.
>>
>> Leah/Tabby can do it, and they can update the queries after
>> each conversion run too, although I could do it also if you want me
>> to for some reason.
>>
>> By way of example, here's the old and new RNKTYPES.Query for ALF:
>>
>> Old:
>> SELECT DISTINCT biograph.sname
>> FROM biograph, members
>> WHERE biograph.sname = members.sname
>> AND members.date >= %s
>> AND members.date <= %f
>> AND members.grp = %g
>> AND biograph.sex = "F"
>> AND NOT(EMPTY(matured))
>> AND matured <= %f
>>
>> New:
>> SELECT DISTINCT biograph.sname
>> FROM biograph, members, maturedates
>> WHERE biograph.sname = members.sname
>> AND members.date >= '%s'
>> AND members.date <= '%f'
>> AND members.grp = %g
>> AND biograph.sex = 'F'
>> AND maturedates.sname = biograph.sname
>> AND maturedates.matured <= '%f';
>>
>> (Note that I have gone ahead and put some of the %
>> substitutions inside single quotes because I believe
>> this makes more sense and is simpler for the ranker
>> program to deal with because it won't have to think
>> about what datatype things are and whether or not
>> it needs to put quotes around things. The final
>> design is up to Jun and Dongdong.)
>>
>> 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
>
More information about the Babase
mailing list