Cheat sheets can be very handy from time to time. Although you probably wont learn much from them, I find them excellent for refreshing my memory. For example if I’ve been working on an ASP project for a while and then have to do some CSS or even worse PHP I often take a while to get my head around the changes in language and format.

I find cheat sheets are great for helping me aclimatise quicker! So here’s a collection of my fevourites:

CSS Cheat Sheets

Now I code something using CSS at least once a day but I still have the need every once in a while to look up some obscure property, so having this CSS cheat sheet lying around comes in handy.

HTML Cheat Sheets

HTML cheat sheets can always come in handy from time to time, bookmark it or print it out so you know where it is when you need it!

jQuery cheat sheets

I’ve been doing a lot of work with jQuery recently and although my javascript isn’t very good this jQuery cheat sheet (and another one from ColorCharge that I cant find on their website anymore) has helped a lot.

ASP Cheat Sheet

PHP Cheat Sheet

MySQL Cheat Sheet

SQL Cheat Sheet

Regular Expressions Cheat Sheet

MOD_REWRITE Cheat Sheet

HTML Characters Chart

Now I realise a lot of these cheat sheets are from the same website, this is just because they’re the best ones I’ve came across. If you know of anoher good cheat sheet that I’ve missed, let me know and I’ll get it up.

I’ll update this post as and when I find new cheat sheets thatI think are worth telling people about.

After some users reported problems using my flexigrid with asp and IE I decided to redo some of the code to fix it.

Basically the problem was that when the JSON code generated it is supposed to add a comma (,) to the end of every line apart from the last one. My code put a comma at the end of every line including the last one. Firefox realises this and fixes the problem while IE just dies and wont show the content. All I did was added a quick if statement to the end of the line that checks to see if it’s the last record retrieved from the database or not and sticks the comma on the end if it has to.

I’ve also been working with flexigrid at work as part of an application I’m making which populates the flexigrid with data users have entered using online forms and PDAs. This presented the problem that people dont always enter alpha numeric characters and flexigrid doesn’t seem to like this so I added a function called cleanup that will remove all non alpha numeric characters from your data before it kills flexigrid. This is also included in the new distro. And as a side note, I have had flexigrid working with 3500 records from a Sybase database a work without any problems.

Again, thanks to Paulo for creating flexigrid in the first place! And you can download the new distro of my asp backend here or see the demo here.

***This version is an outdated version of my script which has some display errors with IE. Please take a look at asp with flexigrid V2.***

I came across a pretty nifty script called Flexigrid. Basically it allows you to take information from a database using JSON or XML and display it on a pretty nifty grid with search, pagination, sorting and some other cool features.

Anyway, all of the examples use PHP to generate the XML or JSON so I decided to do it in ASP using a microsoft access database. You can view a demo of what I made here and download all the files (including the test db) here.

You can also visit the flexigrid website here.