Drupal

Been away from Drupal for a few (combination of Java work and vacation).  My task was to implement a BCC for a particular email that was going out.

I found the hook_mail_alter

I fire up my editor, grab the lates svn updates and plunk down the following "hello hook" into my custom theme. 

Yes, super simple, but it did take me a good 15 minutes to figure out how.
In my mymodule_views_query_alter(&$view, &$query) function, I had access to the $query variable.  Doing a print and print_r of the query object provided a object view of the query, but NOT the underlying SQL
I dug into the views module and discovered the Query class (in views/include) and it described a "query" function that built up the sql string.
 
Hence, this worked for me (it output the sql that the view would generate):
 

Drupal has a custom CCK field for email addresses.  Their is a custom Drupal module that provides this field.  One of the ways that I am using it is to associate different Content types that I have (Students and Faculty) with this field.  Once this field is on that content type, I can hit the "Display Settings" for the content field and choose to use a Contact form. This is a far better option than exposing a naked email address for all the email harvesting spambots out there.

I just got repeating events to display finally on the calendar views.

To summarize:

Sometimes it pays to read the user contributed notes that are part of the Drupal documentation.  If I had done so intially, I would have been done long ago.

The task was to customize the node display of an event to include a "time" only field.  Since the date and time were stored as part of the same CCK Date field, I needed to somehow format the date value to use the time only format string such as: "g:i a"

I setup the custom format in my drupal admin.

I added my format first: