Ok, all Rankdates are rolled back to the first of the month, and all MALE maturedates are rolled back to the first! yay!<div><br></div><div>So are the next steps (for now) </div><div>(1) Niki continues to run the queries for Laurence and we see what errors we still end up with.</div>
<div>(2) Solidify Rules With Susan for Males having MCE after age 4 even if that means prior to matdate</div><div>(3) Once rules are established and enforced, make sure all male MCE's are falling after the decided point, fix all that aren't?</div>
<div><br></div><div>does that cover it?</div><div>L</div><div><br><br><div class="gmail_quote">On Tue, Mar 23, 2010 at 12:19 PM, Lacey Maryott Roerish <span dir="ltr"><<a href="mailto:lroerish4@gmail.com">lroerish4@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">ok ran the following query:<div><span style="font-family:arial, tahoma, verdana, helvetica, sans-serif, serif;font-size:13px"><pre style="font-size:13px;font-family:arial, tahoma, verdana, helvetica, sans-serif, serif">
update maturedates
set matured = rnkdate(matured) from biograph
where biograph.sname = maturedates.sname
and biograph.sex='M';</pre><pre style="font-size:13px;font-family:arial, tahoma, verdana, helvetica, sans-serif, serif">with no errors and 350 rows updated. I ran it in test just to be sure.</pre>
<pre style="font-size:13px;font-family:arial, tahoma, verdana, helvetica, sans-serif, serif">Running same select query in babase returns 350 rows, so it seems like we are getting the correct amount!</pre>
<pre style="font-size:13px;font-family:arial, tahoma, verdana, helvetica, sans-serif, serif">Will run in babase</pre><pre style="font-size:13px;font-family:arial, tahoma, verdana, helvetica, sans-serif, serif">L</pre></span><div>
<div></div><div class="h5"><br><div class="gmail_quote">On Tue, Mar 23, 2010 at 12:04 PM, Karl O. Pinc <span dir="ltr"><<a href="mailto:kop@meme.com" target="_blank">kop@meme.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>On 03/23/2010 10:45:56 AM, Karl O. Pinc wrote:<br>
<br>
><br>
> I think it's safe to fix code so that males don't have to<br>
> be mature. I'll do this now and get back to you.<br>
<br>
</div>Ok. Done.<br>
<br>
Try it again.<br>
<div><div></div><div><br>
<br>
Karl <<a href="mailto:kop@meme.com" target="_blank">kop@meme.com</a>><br>
Free Software: "You don't pay back, you pay forward."<br>
-- Robert A. Heinlein<br>
<br>
<br>
_______________________________________________<br>
Babase mailing list<br>
<a href="mailto:Babase@www.eco.princeton.edu" target="_blank">Babase@www.eco.princeton.edu</a><br>
<a href="http://www.eco.princeton.edu/mailman/listinfo/babase" target="_blank">http://www.eco.princeton.edu/mailman/listinfo/babase</a><br>
</div></div></blockquote></div><br><br clear="all"><br></div></div><div class="im">-- <br>- -<br>Lacey K. Maryott Roerish<br>Alberts Lab<br>Department of Biology<br>Duke University<br>ph: 919-660-7306<br>fax: 919-660-7293<br>
<a href="mailto:Lacey.Maryott@duke.edu" target="_blank">Lacey.Maryott@duke.edu</a><br>
</div></div>
</blockquote></div><br><br clear="all"><br>-- <br>- -<br>Lacey K. Maryott Roerish<br>Alberts Lab<br>Department of Biology<br>Duke University<br>ph: 919-660-7306<br>fax: 919-660-7293<br><a href="mailto:Lacey.Maryott@duke.edu">Lacey.Maryott@duke.edu</a><br>
</div>