Posts Tagged “INSERT”

It is not obvious how to insert multiple rows in a Google Docs spreadsheet anywhere in the spreadsheet. Google has a button to add a variable number of rows at the bottom of the sheet shown below, but no obvious button to insert anywhere in the sheet.

google_spreadsheet

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , ,

Comments No Comments »

Earlier today I was troubleshooting some resource issues on a PostgreSQL server and needed to test some various SELECT statements to see if any of them were causing problems. I also wanted to verify the amount of resources a SELECT statement made using PGAdmin versus the amount of resources the same SELECT statement used running it directly on the Postgres server itself. Below is information on how to run a SELECT statement from a Linux shell. In this example the server is running CentOS Linux and PostgreSQL 8.4.4.

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , , , , , , , , , , , , , ,

Comments No Comments »

Recently I have been sending a lot of emails to a colleague in Portugal whose name ends é. While I was told it is not so rude to simply not include the accent above the E I actually prefer to include the accent to display respect since he actually includes the accent over the E in his signature. Since I am using Outlook 2007 the below Outlook keyboard shortcut will provide the easiest method for you to insert an E with an accent over the top in emails that you compose. After information related specifically to the accent over the E I also discuss inserting other non English symbols into email messages composed with Outlook.

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , , , , , , ,

Comments 2 Comments »

If you have lost your ZenCart admin password it can be reset as long as you have access to PHPMyAdmin on the server or direct access to the MySQL database. If you have lost the admin password however  the admin account is configured with your email address you can simply use the “Resend Password” link located at the bottom of the admin login box to have a new password sent to you. If that doesn’t work or your email address is not configured for the admin account the easiest way to modify the Admin password will be to login to the server via SSH and follow the directions below.

Manually Change ZenCart Admin Password:

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , , , , , ,

Comments 4 Comments »

I was attempting to view the contents of what I thought was a SQLite3 database file so I needed a GUI of some sort to do so. Anyhow first I decided to install SQLite. Once I did this and created a test database to make sure to SQLite GUI was working I finally decided the file I was trying to open was not a SQLite3 database file.

Install/Run SQLite:

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , ,

Comments 21 Comments »