Sorry, misread that as nodes not comments.<br><br>Does <i>Filters -> Comment: In moderation</i> do what you want?<br><br>Brian<br><br><div class="gmail_quote">On Fri, Jul 31, 2009 at 6:37 PM, Brian Choc <span dir="ltr"><<a href="mailto:bchoc@t4tcolorado.org">bchoc@t4tcolorado.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">It's in Filters -> Node: Published.<br><br><div class="gmail_quote">On Thu, Jul 30, 2009 at 2:19 PM, Steve Kessler <span dir="ltr"><<a href="mailto:skessler@denverdataman.com" target="_blank">skessler@denverdataman.com</a>></span> 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 bgcolor="white" link="blue" vlink="purple" lang="EN-US">
<div>
<p><span style="color: rgb(31, 73, 125);">Thank you very much. </span></p>
<p><span style="color: rgb(31, 73, 125);"> </span></p>
<p><span style="color: rgb(31, 73, 125);">There does not appear to be
published/unpublished toggle available in views. </span></p><div>
<p><span style="color: rgb(31, 73, 125);"> </span></p>
<p><span style="color: rgb(31, 73, 125);">Thanks,</span></p>
<p><span style="color: rgb(31, 73, 125);">Steve</span></p>
<p><span style="color: rgb(31, 73, 125);"> </span></p>
<div>
<p><span style="color: rgb(31, 73, 125);">Steve
Kessler </span></p>
<p><b><span style="color: rgb(72, 110, 149);">Denver DataMan </span></b></p>
<p><span style="color: rgb(31, 73, 125);">303-587-4428
</span></p>
<p><span style="color: rgb(31, 73, 125);"><a href="http://www.denverdataman.com/content/enewsletter-signup" target="_blank">Sign up for the
Denver DataMan Free eNewsletter</a></span><span style="color: rgb(31, 73, 125);"></span></p>
</div>
<p><span style="color: rgb(31, 73, 125);"> </span></p>
</div><div>
<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;"> Neil Coghlan
[mailto:<a href="mailto:neil@esl-lounge.com" target="_blank">neil@esl-lounge.com</a>] <br>
<b>Sent:</b> Thursday, July 30, 2009 11:46 AM<br>
<b>To:</b> <a href="mailto:support@drupal.org" target="_blank">support@drupal.org</a><br>
<b>Subject:</b> Re: [support] Comments needing approval block</span></p>
</div>
</div><div><div></div><div>
<p> </p>
<div>
<p><span style="font-size: 10pt;">this
is what I have in a block, alongside some other stats:</span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
</div>
<div>
<p><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
</div>
<div>
<p><span style="font-size: 10pt;"><b><span
style="color:red;"><?php<br>
$count_unpub_comm_tot = db_result(db_query("SELECT COUNT(cid) FROM
{comments} WHERE `status` = 1"));<br>
echo $count_unpub_comm_tot;<br>
?></span></b> <b>Un</b>published Comments</span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
</div>
<div>
<p><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
</div>
<div>
<p><span style="font-size: 10pt;">with
Views, I imagine it would be even easier, no? Just use unpublished filter.
Preferred to roll my own though.</span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
</div>
<div>
<p><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
</div>
<div>
<p><span style="font-size: 10pt;">Neil</span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
</div>
<blockquote style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color black; border-width: medium medium medium 1.5pt; margin: 5pt 0in 5pt 3.75pt; padding: 0in 0in 0in 4pt;">
<div>
<p><span style="font-size: 10pt;">-----
Original Message ----- </span></p>
</div>
<div>
<p style="background: rgb(228, 228, 228) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> <a href="mailto:skessler@denverdataman.com" title="skessler@denverdataman.com" target="_blank">Steve Kessler</a> </span></p>
</div>
<div>
<p><b><span style="font-size: 10pt;">To:</span></b><span style="font-size: 10pt;"> <a href="mailto:support@drupal.org" title="support@drupal.org" target="_blank">support@drupal.org</a>
</span></p>
</div>
<div>
<p><b><span style="font-size: 10pt;">Sent:</span></b><span style="font-size: 10pt;"> Thursday, July 30,
2009 2:28 PM</span></p>
</div>
<div>
<p><b><span style="font-size: 10pt;">Subject:</span></b><span style="font-size: 10pt;"> [support] Comments
needing approval block</span></p>
</div>
<div>
<p><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
</div>
<p>I am trying to create a block of comments that need
approval. I have tried many iterations of ways to do this and I cannot figure
it out. I would like to do this with views. If anyone can give me a
suggestion I would appreciate it.</p>
<p> </p>
<p>Thanks,</p>
<p>Steve</p>
<p> </p>
<p><span style="color: rgb(31, 73, 125);">Steve
Kessler </span></p>
<p><b><span style="color: rgb(72, 110, 149);">Denver DataMan </span></b></p>
<p><span style="color: rgb(31, 73, 125);">303-587-4428
</span></p>
<p><span style="color: rgb(31, 73, 125);"><a href="http://www.denverdataman.com/content/enewsletter-signup" target="_blank">Sign up for the
Denver DataMan Free eNewsletter</a></span></p>
<p> </p>
<div style="text-align: center;" align="center"><span style="font-size: 12pt; font-family: "Times New Roman","serif";">
<hr align="center" size="2" width="100%">
</span></div>
<p><span style="font-size: 12pt; font-family: "Times New Roman","serif";">--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]</span></p>
</blockquote>
</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><br>
</blockquote></div><br>