Keyboard Face

when you find QWERTY imprinted on your cheek - it's time to go to bed.

Tags

asp CSS css menus dreamweaver flash gallery2 hosting iis7 Javascript jquery jquery ui left mac mssql os9 php printer rdp SEO sql sql server windows wordpress

Archives for January 2009

Testing Your CSS and HTML accross multiple browsers

by 1 Comment

It’s very important to test your code on multiple browsers. Your audience could have any of them and you want your site to look the best no matter what, even if they have an ancient computer.

I’ve found several very good resources out there that have excellent free options.

CrossBrowserTesting.com

I love this site. It actually gives you a remote desktop session with the OS and the browsers that you need to test.
NOTE: They used to have a free option, but it is gone now. Lowest cost is $19.95 for one month subscription.

BrowserShots.org

Enter your URL and it returns screen shots of your site in over 80 browser and OS combinations. It even gives you the option of downloading them all as a zip file. Extremely handy!

Lastly, if your site is running into problems with older versions of IE, there is no easy way to install previous versions of IE on top of a more current version.

Tredo Soft has a program you can install called Multiple IE’s. It lets you do just what you couldn’t. Install previous versions of IE and test them on your computer. No more waiting for browser sessions on CrossBrowserTesting.com just to test IE! Here is the link:

http://tredosoft.com/Multiple_IE

If you’re using Vista, Multiple IE’s won’t work, however. You may need to use My DebugBar’s IE Tester:
http://www.my-debugbar.com/wiki/IETester/HomePage

Best,
Tom

Filed Under: CSS

MSSQL Large Sub Query Impossibility

by Leave a Comment

I recently had to query to find out how many records from one table were not in another really large table. When you do a select statement like this in MSSQL it overflows and gives you a response of 0. Not very helpful:

select count(*) from Table1 where Field Not In (Select Field from Table2)

All other ideas failing, I finally resorted to writing a query using a temp table variable:
set nocount on;
declare @Tables table (
PK int IDENTITY(1,1),
Field1 varchar(100), Field2 varchar(100)
);
insert into @Tables(Field1 , Field2 )

select t1.Field, t2.Field from Table1 t1
left outer join Table2 t2 on
t1.Field = t2.Field;

set nocount off;
select count(*) as Count, Field1 from @Tables
where Field2 is Null
Group by Field1
Having Count(*) < 2;

Talk about complicated! If you have any other better ways of doing this – please let me know!