Sunday, January 23, 2011

Black Bean & Roasted Red Pepper Dip

Don't know where I found this but it was stored as a random txt file on my computer.

Black Bean & Roasted Red Pepper Dip
1 pkg(1 oz.) taco spices & seasonings
1 can(15 oz.) black beans, rinsed and drained
1 jar(7 oz.) roasted red peppers, drained
1 pkg(12 oz.) light cream cheese
1 Tbsp. chopped cilantro
1 to 2 teaspoons lime juice
Garnishes: chopped tomato and fresh cilantro

In food processor combine all ingredients except garnishes; mix thoroughly. Makes 2 cups.

Tuesday, January 18, 2011

Drupal site move results in off-line message

I recently moved a Drupal site from test to production. I followed the standard line for moving a site. When I went to access the new site it told me the site was off-line. My big problem was that my log files weren't telling me anything useful, nothing at all. I kept poking around and finally figured out I had made a typo when setting up the database and didn't have the MySQL permissions assigned correctly. As soon as the proper grant was issued on the database the site immediately became available.

Monday, January 3, 2011

Greenplum update with multiple tables

Recently ran into an issue using Greenplum to update a column. I had column1 in tableA that needed to be set to the value of column1 in tableB. Finally came across the correct syntax here. This is what I was looking for:

UPDATE tableA 
SET col1 = tableB.col1 
FROM tableB 
WHERE tableA.col2=tableB.col2;