If you are facing problems with SQL queries, don’t panic.. take printout of the tables and start writing logical queries on paper. You will get the solution…

If you are facing problems with SQL queries, don’t panic.. take printout of the tables and start writing logical queries on paper. You will get the solution…

If you are facing problems with SQL queries, don’t panic.. take printout of the tables and start writing logical queries on paper. You will get the solution…

and yea.. it works.. tried and tested just now…

Okay, now this one is bit of techie stuff and might go over the head for many readers.

For last few days I have been playing around with Subversion (SVN) for project version management. (It is a version control system basically).

I use Tortoise SVN to control the SVN from my machine (Update / commit etc..) but it was kind of cumbersome to update the folders every time. So, after using powers of Google, I finally found a Dreamweaver extension which lets me update / commit files directly from Dreamweaver. No need to go to that folder and update the stuff. Just right click on the folder in Dreamweaver and update it.

You can get this extension from here.

Technically, it works along with Tortoise SVN and provides SVN options in Dreamweaver. It is free, works well for me and I am happy in the end

It took me quite sometime to fix few things in IE7. Earlier I used to use * html for conditional CSS in IE. But unfortunately it does not work in IE7.

But for IE7, you can use conditional comments for your CSS fixes specific to IE7.

You can use following code in the header of your html file:

<!–[if IE 7]><link rel=”stylesheet” type=”text/css” href=”/styles_ie7.css” /><![endif]–>

In this specific file, you have to put only IE7 specific id and class definitions. IE7 will automatically overwrite the old definitions with new one.

More info on it here

Okay, this might be useless for normal users but this will be very helpful for the designers and HTML coders who always want their site to look perfect in most of the browsers. This recent update of IE6 to IE7 broke few things which made some sites look different in both the browsers.

So, now the question comes in mind is “how to check our site in both the versions of the browser?”

Well, it is possible. This might not be a new thing for few people but I am sure this is going to help someone here.

You can install standalone versions of IE on your machine. If you have already installed IE7 and want to install previous versions of IE, you can get standalone version from here or if you have IE6 on your machine and wish to install IE7 too (keeping IE6 intact) then you can download standalone version of IE7 from here.

I just installed IE6 standalone version on my machine and it really made my testing job lot more easier.

IE seems to act worst when it comes to CSS. You will end up banging head but you won’t be able to trace the problem for the issue.

Similar thing happened to me today when a friend told me that in IE it is showing character O on the left side of the page. (Check boxed area in the screenshot)

I tried to trace it myself but did not get any success so finally SitePoint forums came for the rescue and I got to know that my page was suffering from Duplicate character bug in IE. It was happening due to comments between floats.

I had placed comments between the left_box and right_box. So those comments were making things worse and the last character from right side link (View Our Portfolio) was getting repeated.

The problem got fixed once I remove those comments.

It’s pretty funny that we bang our head for these things, just to know that it was some stupid IE bug. lol