Random bits of info

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.

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.

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;