Home

blog

Some pretty nifty SQL

Wed, 06/11/2008 - 14:21 — davedelong

So at work today I came up with this:

  1. SELECT
  2.         node.title,
  3.         node.nid as node_id,
  4.         DATE.field_date_value as DATE,
  5.         money.field_amount_amount as gift,
  6.         money.field_amount_currency as gift_currency,
  7.         donor.title as donor_name,
  8.         donor.nid as donor_id
  9. FROM drupal_node as node
  10.         INNER JOIN drupal_content_field_date as DATE ON (DATE.nid = node.nid)
  11.         INNER JOIN drupal_content_type_gift as money ON (money.nid = node.nid)
  12.         INNER JOIN (
  13.                 SELECT d.nid, d.title, owner.nid as node_id FROM drupal_node as d

Cocoa Camp!

Fri, 05/09/2008 - 10:33 — davedelong

Apple, for the first time this year, is holding what they're calling "Cocoa Camp." It's a week long crash course in Cocoa for college students (taught by Apple Engineers) at Apple's campus in Cupertino. It was hardly publicized at all. I think I found maybe three solid references to it on Google. I heard about it from a friend of mine who's a friend of the Apple Recruiter for BYU and who also happens to be heading it up. So I applied (as did a number of other of BYU students), and got in!

Drupal Content Types

Fri, 05/09/2008 - 10:12 — davedelong

Content Types are really the heart of how Drupal stores and organizes information. A content type is a definition of a kind of information that a site can store. For example, you can have a content type that defines what a "Job Posting" is like, or what a "Blog Entry" is like, or what a "Hotel Room" contains, and so on.

My Introduction to Drupal

Fri, 05/02/2008 - 12:14 — davedelong

Prior to interviewing with BYU's Computer Science Department for a job as a web developer, I hadn't ever heard of Drupal before. I'd used Wordpress, which I thought was decent (if somewhat inflexible), and I'd only heard of Joomla or Mambo in passing. Drupal was a new beast for me.

As soon as I was hired, I had to plunge straight in. I should warn you, I'm a programmer at heart, so I took to Drupal very quickly. There are still some things that flummox me, but I feel that I understand the system.

New everything...

Tue, 04/29/2008 - 16:38 — davedelong

Well, I've done it again. I've gone and changed the underlying content management system that I use on my site. I've gone with the CMS Drupal, which I've come to know quite intimately ever since beginning work for BYU's Computer Science Department.

Syndicate content