<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16890" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=808113520-10102009>For the most part I
am finding converting my queries fairly straightforward. But I just ran into one
that I'm having a bit of trouble with:</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><SPAN
class=808113520-10102009>ORDER BY ' . ($filters['block_type'] == 0 ? 'RAND()' :
'n.created DESC')</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=808113520-10102009></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=808113520-10102009>Obviously the one
case will end up as "<FONT face="Courier New"
color=#0000ff>->orderBy('n.created', 'DESC')</FONT>", but there's no column
for RAND. Do I just make one up (maybe nid)?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face="Comic Sans MS" color=#ff00ff size=4>Nancy E. Wichmann,
PMP</FONT></DIV>
<DIV align=left><FONT face=Arial size=2><FONT face="Courier New">Injustice
anywhere is a threat to justice everywhere. -- Dr. Martin L. King,
Jr</FONT>.</FONT></DIV>
<DIV> </DIV></BODY></HTML>