ok ran the following query:<div><span class="Apple-style-span" style="font-family: arial, tahoma, verdana, helvetica, sans-serif, serif; font-size: 13px; "><pre class="data" 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 class="data" 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 class="data" 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 class="data" style="font-size: 13px; font-family: arial, tahoma, verdana, helvetica, sans-serif, serif; ">Will run in babase</pre><pre class="data" style="font-size: 13px; font-family: arial, tahoma, verdana, helvetica, sans-serif, serif; ">
L</pre></span><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">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 class="im">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 class="h5"><br>
<br>
Karl <<a href="mailto:kop@meme.com">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">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>-- <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>