<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:12pt"><div><span>Using the Boombatower conversion tool, my query comes out to:</span></div><div><span> $users = db_select('user_badges_user', 'ubu')<br> ->fields('u', array('uid', 'name'))<br> ->condition('ubu.bid', $badge->bid)<br> ->join('users', 'u', 'u.uid = ubu.uid')<br> ->execute();<br></span></div><div><br><span></span></div><div><span>But when I run this, I get:</span></div><div><b>Fatal error</b>: Call to a member function execute() on a non-object</div><div><br></div><div>Joins are getting to be a major pain in the derriere.</div><div><br></div><div>Trying this also fails with the same
message:</div><div><span> $users = db_select('user_badges_user', 'ubu')<br>
->fields('u', array('uid', 'name'))<br>
->condition('ubu.bid', $badge->bid)<br>
->join('users', 'u', 'u.uid = ubu.uid');<br>
$users->execute();<br>
</span></div>
<div><br></div><div>------------------------------------------------------------------------------------------------------------<br></div><div>And does anyone know why I so rarely get answers to my questions on this list?<br>
</div><div> </div><div><font color="#ff007f" face="bookman old style, new york, times, serif" size="4"><i><strong>Nancy</strong></i></font></div> <div><font face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</font></div></div></body></html>