Thanks Brian, Paul, and Craig,<br><br>Duhh. Okay, now I see it. I thought I&#39;d have to chose the field and then expected random to be in the drop-down that has ascending/descending.<br><br>But it&#39;s not that way, so my eyes missed it.<br>
<br>Thanks much, this is perfect.<br><br>Shai<br><br><div class="gmail_quote">On Tue, Jul 15, 2008 at 6:15 PM, Brian Choc &lt;<a href="mailto:bchoc@t4tcolorado.org">bchoc@t4tcolorado.org</a>&gt; wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">









<div link="blue" vlink="purple" lang="EN-US">

<div>

<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Add the criteria "Random" (it's listed as a field) … does that
do what you're looking to do?</span></p>

<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">&nbsp;</span></p>

<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Brian</span></p>

<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">&nbsp;</span></p>

<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">&nbsp;</span></p>

<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">

<p><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;">
<a href="mailto:support-bounces@drupal.org" target="_blank">support-bounces@drupal.org</a> [mailto:<a href="mailto:support-bounces@drupal.org" target="_blank">support-bounces@drupal.org</a>] <b>On Behalf Of </b>Shai
Gluskin<br>
<b>Sent:</b> Tuesday, July 15, 2008 4:12 PM<br>
<b>To:</b> <a href="mailto:support@drupal.org" target="_blank">support@drupal.org</a><br>
<b>Subject:</b> [support] Getting A View to &quot;ORDER BY RAND ()&quot;</span></p>

</div><div><div></div><div class="Wj3C7c">

<p>&nbsp;</p>

<p>I have a need for Views to &quot;ORDER BY RAND ()&quot;<br>
<br>
The use-case is that I want to pull in the teaser of a particular content-type
for one node only onto the home page. I want it to randomly select the node it
displays.<br>
<br>
Everything is easy except the random part. The home page is a panel page. I&#39;ve
built a view, filtered on content-type, set the number of nodes to display at
&quot;1&quot; -- successfully pulled it into the panel.<br>
<br>
I thought the way to do this would be to set a sort criteria. But I see only
&quot;ascending&quot; and &quot;descending&quot; -- I don&#39;t see
&quot;random&quot; as a choice.<br>
<br>
Any ideas?<br>
<br>
I&#39;m using Drupal 5.8,&nbsp; Views 1.6 and Panels 2 Beta<br>
<br>
Thanks,<br>
<br>
Shai</p>

</div></div></div>

</div>


<br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br>