Here’s a method of generating a dynamic pivot of a dataset. It first generates the columns as a string (“[ColumnHeader0],[ColumnHeader1],[ColumnHeader2], …” format), builds a dynamic SQL string and executes it using the PIVOT expression. From the code below, the @cols variable is generated by using the FOR XML PATH expression. …
UPDATE 10-08-2012: Here’s a blog entry on how to determine if the device you’re on has touchevents enabled. Note that most Javascript libraries/frameworks should already have some sort of detection for this built in. My demo for using Cubiq.org’s SpinningWheel control stopped working on iOS6. The issue was that I …
Do you have the new MacBook Pro Retina? Running Mountain Lion 10.8.1 or less? Are you having battery life issues? Then head on over to cultofmac.com, which has a fix that worked for me. It seems that there’s a issue with a configuration file called com.apple.desktop.plist that resides in your …
It probably won’t be often, but sometimes you may find yourself having the need to load Javascript dynamically using XHR. To name a few use cases: Developing a plugin architecture for an HTML5 application. In order to extend your application’s functionality. Load certain Javascript depending the browser environment. A …
Kind of a cool effect. Here’s an example: To get the image reflect on the bottom, I used the following CSS: -webkit-box-reflect: below 5px -webkit-gradient( linear, left top, left bottom, from(transparent), color-stop(0.75, transparent), to(rgba(255,255,255,0.3)) ); Here’s some other options: Basic -webkit-box-reflect: below; Offset -webkit-box-reflect: below 5px; Masking with Gradient -webkit-box-reflect: …
I had an issue in my iOS application at work where there was a long pause while the view for a QR reader was initializing. So I decided to use Cocoa’s Activity Indicator to try to give a better user experience. I would show the indicator before the view initialized …
At work, I needed to create a script that did several checks such as verifying disk space and CPU utilization; this script is to be run on a number of servers. We wanted to keep a daily record for historical and trending purposes. So, I created a script that performed …
I got the following error when trying to connect to my web service using NSURL: Failed with error: Error Domain=NSURLErrorDomain Code=-1000 “bad URL” My URL was a GET request and so had several parameters in it. At first, I tried to URL encode the spaces manually using %20 (you’ll have to use …
This is a list of CSS properties across the four major browser engines: Webkit (Chrome and Safari), Gecko (Firefox), Presto (Opera), and Trident (IE). Useful if you want to ensure some of your CSS3 effects are compatible. See peter.sh
I was playing around with Wink Toolkit’s Tag Cloud control and came across an interesting issue with Chrome and the CSS3 matrix3d transform function. In order for the z coordinate to work properly in the matrix3d parameters, you’ll need to set the parent element’s -webkit-transform-style property to preserve-3d. The following example …