Elias Saba’s Blog

My sister called to tell me the LCD screen on her digital camera was cracked. I told her not to worry since the camera was pretty old already, but that I would check to see how much a replacement screen would cost. I first checked my favorite “cheap stuff from china” site, DealExtreme.com, but unfortunately they didn’t carry the screen for he exact model, a Canon SD300.

The next cheapest place to find the right part would undoubtedly be eBay. I loaded eBay’s homepage and searched for sd300 screen (All eBay search queries will be green in this article). That resulted in 9 matches. I’m sure some people would be content with these 9 result, but you and I know better. There must be more than 9 auctions for the item I want. Here is how to find them efficiently.

Searching eBay for sd300 screen resulted in 9 matches. The next thing most people would do is modify their search query. How about the word “lcd”? Some sellers might use the word “lcd” instead of “screen”, right? The worst thing you could do is to just add “lcd” to the query and search for sd300 lcd screen. This resulted in 7 matches. This new query is worse because eBay uses an AND operator by default. This means that searching for sd300 lcd screen will bring up auctions with the word sd300 AND lcd AND screen. All three words must be in the auction title to be a match. You didn’t want to narrow down your search, you wanted to broaden it.

Most people understand that eBay’s search works this way; the more words you add to a query, the fewer matches you will get. So instead of adding “lcd” to the original search, you should replace “screen” with “lcd”, right?  Wrong.  Searching for sd300 lcd returns 13 matches. While we did find more auctions, most of them are duplicates from our previous search for sd300 screen (because they include both “screen” and “lcd” in the title) and even worse, we actually lost all auctions that have the word “screen” but don’t have the word “lcd”.

Our goal here is efficiency. You could of course search for sd300 screen and peruse the results, then search for sd300 lcd and peruse the results, then tweak the query a little more and see what comes up, and continue this pattern until you have scowerd every inch of eBay for the item you’re looking for. The problem is with each new query you will be wasting time skimming through auctions you’ve already seen in previous queries. The solution to this is eBay’s OR operator.

If you place words inside a set of parenthesis and separate them by commas, eBay will apply an OR operator to those words instead of the default AND operator. The easiest way to further explain this is through examples. If we search eBay for sd300 (screen,lcd) it is the equivalent of combining the results for sd300 screen with the results for sd300 lcd and removing all duplicate auctions. In other words, you are telling eBay to give you all auctions that contain the word “sd300″ AND either the word “screen” OR “lcd”. Searching eBay for sd300 (screen,lcd) returns 15 matches. We now have all 13 auctions from the sd300 lcd search, plus the two we lost when we removed “screen” in one efficient list.

Are we done? Of course not! eBay is huge! 15 results is pathetic! There should be more! Strike that, there MUST be more! More! MORE!

While searching for sd300 (screen,lcd) we see many auctions include “sd200″ and “sd400″. This probably means all three camera models use the same screen. A quick bit of research proves this to be true and so our new eBay search is for (sd200,sd300,sd400) (screen,lcd) with a result of 17 matches. This means there were two auctions for “sd200″ or “sd400″ screens which didn’t have the word “sd300″ in the title. If we searched for sd200 (screen,lcd) then for sd300 (screen,lcd) and then for sd400 (screen,lcd) separately, we would have had to sift through 3 different lists with 40 items total just to see 17 unique auctions. Are you starting to see how powerful the OR operator is? No? Then read on.

Analyzing the results of our search further we notice many include “IXUS” in the title. A quick Google search reveals the Canon SD line is called the Canon IXUS line outside of the US and that the sd200/sd300/sd400 are the same as the ixus30/ixus40/ixus50. Since they all use the same LCD screen, we might as well include that in our serach. Now our search is for (sd200,sd300,sd400,ixus30,ixus40,ixus50) (screen,lcd) and returns 20 matches. But we’re not done yet. We need to account for sellers who chose to use “ixus 30″ in their title instead of “ixus30″. The last search does not inlcude auctions with a space between the letters and numbers in the camera’s model characters. The all inclusive search query becomes (sd200,sd300,sd400,ixus30,ixus40,ixus50,”sd 200″,”sd 300″,”sd 400″,”ixus 30″,”ixus 40″,”ixus 50″) (screen,lcd) and ads 3 more auctions for a total of 23 matches.

We have greatly improved from our initial 9 results from searching for sd300 screen. We could stop here and be happy with our selection of matching auctions, but there’s one more group of candidates not included in our search result yet. Skimming the current results I noticed one auction for a broken sd400 camera. It found its way into our search because the seller specified in the auction title that the “LCD works”. Since the price of a broken camera with working screen isn’t much more than a screen alone, it makes sense to include auctions for broken cameras matching our list of compatible models. We could create a separate query just for this group, but there really is now need when we can easily add key words like “broken”, “repair”, and “parts” to our current query. This brings our final search query to (sd200,sd300,sd400,ixus30,ixus40,ixus50,”sd 200″,”sd 300″,”sd 400″,”ixus 30″,”ixus 40″,”ixus 50″) (screen,lcd,broken,repair,parts) which gives us a grand total of 61 auctions potentially selling the item we want to purchase. With all auctions on one list we can sort the results and easily compare our options.

To put our new search query into perspective, it is the equivalent of searching for all of the following and removing the duplicate auctions:

So you connected a hard drive to Windows XP, you right-clicked on the drive inside “My Computer”, you selected “Format…”, you went to change the “File system” option from NTFS to FAT32, and finally you mashed your head into your monitor because windows is not giving you the option to select FAT32 even though you know you’ve seen it there before.

Don’t fret. I just went through this process moments ago and here is how I got around it:

NOTE: This process will delete all data on your drive!

1. Download fat32format.exe (zip)
Don’t worry, you don’t have to install anything. It’s just a single file standalone utility you’ll use once and delete.
2. Place fat32format.exe in your C:\ folder
3. Right-click on “My Computer” and select “Manage”
4. Click “Disk Management” on the left under “Storage”
5. Right-click on the drive you want formated to FAT32 and select “Delete Partition…”
6. Click “Yes” to delete all partitions
7. Right-click on the same drive and select “New Partition”
8. A wizard will open up, click “Next” to continue
9. Select “Primary Partition”
10. Enter the partition size
11. Choose a drive letter and remember it (for example: “F”)
12. Select “Do not Format this partition”
13. Click finish
14. Open a command prompt (Start menu -> Run… -> type: “cmd” -> Click OK)
15. Type “C:\fat32format F:” and hit enter (where “C” is the drive you placed fat32format.exe in step 2, and “F” is the drive letter you selected in step 11)
16. Type “y” and hit enter
17. Close everything and enjoy your FAT32 drive.

Since people commented about my cat page on my first introductory post, I created a post about a cat page and figured out how to move the cat page comments from my first post to the new cat page post.

For those wanting to know how to move a comment from one entry in WordPress to another entry, here is how to do it.

These instructions work for version 2.3.3 of WordPress. Depending on how much WordPress has changed over the years, this method may or may not work on different versions. You can find out which version of WordPress you have by looking in the footer at the bottom of your admin interface.

First you need access to your WordPress MySQL database. The easiest way is to use MySQL’s web interface, phpMyAdmin. To get to phpMyAdmin, enter your database hostname into the URL field of your browser and press enter. If you happen to be using Dreamhost as your webhost, you can login to their control panel, click “Goodies” from the left side bar, click”Manage MySQL”, locate your WordPress database, and click the phpMyAdmin link under the “Web Administrator” column associated with your WordPress database. You will need to login to phpMyAdmin to access your database. The database username and password you entered when setting up WordPress should work.

If you forgot your WordPress hostname, database username, or database password, you can find them at the top of the file “wp-config.php” in your WordPress directory.

1. Once you’re in phpMyAdmin, select your WordPress database from the database drop down menu on the left.
2. Enter the post table by clicking the link from the left which ends in “_posts”.
3. Click the “Browse” tab at the top of the page that loaded to view the table with all your posts.
4. Locate the post you want the comment moved to and take note of the number in the “ID” column associated with that post.
5. Click the edit icon (looks like a pencil) associated with the post you just found.
6. Scroll down to the bottom and find the field labeled “comment_count”.
7. Increase the number in the field by how many comments you will be moving to that post. For example, if the comment count of that field is “5″ and you will be moving two comments to that post, then change the comment count to “7″.
8. Click the “Go” button at the bottom of the page to save your changes.
9. Now locate the table entry for the post you are removing the comment from.
10. Click the edit button associated with that post.
11. Decrease the number in the “comment_count” field by the number of comments you are removing from that post.
12. Click the “Go” button at the bottom of the page to save your changes.
13. Now click the link that ends in “_comments” from the list of database tables on the left.
14. Click “Browse” to bring up the table holding all your comments.
15. Locate the comment you want to move.
16. Click the edit icon associated with that comment.
17. Find the “comment_post_ID” field and change the value in that field with the post ID of the comments new home which I told you to take note of earlier.
18. Click the “Go” button at the bottom of the page to save your changes and you’re done.