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.

Note I've found all these directions on making it work even when installing port php52 it simply does not work. I'm still trying to get this to work. ack.

Great post on a site that is eerily exactly like this one!
http://stevepurkiss.com/blog/steve-purkiss/2009/04/15/setting-seo-frien…

After opening a lightbox with thickbox: see http://jquery.com/demo/thickbox/

You can close the lightbox and have an href link open a url in the parent window:

Register for an Infinite Connection account.

Also to have a form and click submit but close the lightbox and have the form submit to the parent page use this code.

<?php
$output .= "
?>

this took me an hour or two to figure out, so you're welcome :)

I use the following code to conditionally show pieces of the page depending on which page the user is on:

$curr_uri = check_plain(request_uri());
//print $curr_uri;
<?php if ((!preg_match("/contact/i", $curr_uri))&&(!preg_match("/authentication-options/i", $curr_uri))&&(!preg_match("/node\/305/i", $curr_uri))) : ?>
conditional html code here
<?php or php code here to be conditionally shown?>
<?php endif; ?>