Drupal 5: http://drupal.org/node/16383
Drupal 6: http://drupal.org/node/223430

http://drupal.org/writing-secure-code

Just a link for a refresher on making sure you're writing secure code.

Great post here on this site: http://www.pixelclever.com/how-theme-specific-blocks-drupal

Replace the corresponding function above with whats below to get recent posts in your drupal block

Here's a module that may do it http://drupal.org/project/views_modify_query, or use the code below:

Here is the module I wrote:
removedups_view.module is listed below

http://drupal.org/node/310075

took me forever to find this.

#!/usr/bin/perl
print "Content-type: text/html\n\n";
 
$title='Perl Mail demo';
$to='MAIL ADDRESS TO SEND TO';
$from= 'webmaster@YOURDOMAIN.COM';
$subject='YOUR SUBJECT';
 
open(MAIL, "|/usr/sbin/sendmail -t");
 
## Mail Header
print MAIL "To: $to\n";
print MAIL "From: $from\n";
print MAIL "Subject: $subject\n\n";
## Mail Body
print MAIL "This is a test message from Cyberciti.biz! You can write your
mail body text here\n";
 
close(MAIL);
 
print "$title\n\n\n";
 
## HTML content sent, let use know we sent an email
print "
$title
 
A message has been sent from $from to $to
 
";

To access Salesforce via a desktop application or other API-based application, you must replace your current password with a combination of your password and a security token:

1 Log in to Salesforce via the browser to request your security token.

2 Go to Setup -> My Personal Information -> Reset Security Token.

3 Click the Reset Security Token button to trigger an email which will contain your security token.

4 Select and copy the token from the email.

good drupal.org documentation is here: http://drupal.org/node/101496 getting a single value: use db_result

$result=db_result(db_query('Select uid from {users} where uid = %d',5));

getting multiple rows: use db_query

The data is here for example for content type event_calendar:
So just look for your content type using the same naming convention.