Posts
288
Comments
25
Trackbacks
207
October 2006 Entries
IE DOM and style attributes

As much a reminder to myself as aid for anyone with a similar problem. I've been doing some client-side scripting, using the HTML DOM and hit a problem when accessing the attributes of an element, specifically the style attribute. IE returns this as an object, while other browsers (well, Firefox) return it as a string, in accordance with the W3C specs. In IE to get access to the string of defined values you have to use node.style.cssText. It's taken me several hours of trial an error and searching to find this - most of my search results had plenty to say about problems of setting and fetching CSS values, but not mentioned this property, which I eventually found on MSDN.

Listening to See Him on the Street by The Jayhawks from the album Tomorrow the Green Grass

posted @ Monday, October 30, 2006 3:49 PM | Feedback (0)
What happens when the connection dies ...

Don't tell me this hasn't happened to you and you haven't felt the same.

posted @ Wednesday, October 25, 2006 6:56 PM | Feedback (1)
Reporting Services

Yet another software complaint. Ignoring all the direness that is the SQL Reporting Services Designer, which I really don't think is as easy to use as the one that Access has had for 10 years, I have the install / configuration issue. SSRS wasn't working so I had to manually configure; there's a nice tool provided, but that still led to permissions problems on a config file. So I tried the trusted route of uninstalling and re-installing the reporting services and I find the reason for it not being configured; when installing you get a selection of "Install the default configuration" or "Install but do not configure", the latter of which is selected and the radio buttons grey out. Apparantly the installation thinks "the SQL instance is either not selected or is not a local install", neither of which are correct. It's a local machine and the default instance. I really like the way the error doesn't actually tell you what it thinks the values are, but just tells you they are wrong, when you clearly know they aren't.

Error messages that tell you next to nothing suck.

So do I now have to uninstall the entire SQL product to reinstall and see if it works? Probably. Sigh.

posted @ Friday, October 20, 2006 12:34 PM | Feedback (2)
Great weekend thanks to great friends

My great weekend started on Friday when I went to a gig with Jon. In itself this isn't an unusual event, as we go to a fair number of gigs. But this was special. Jon and I are both fans (devotees? Addicts?) of Bob Harris, who recently had a Chris Rea competition; Jon won tickets to to a session Chris was recording for Bob's Saturday show. As Lou isn't the biggest Chris Rea fan (her own words) she offered me the chance to go instead, which I jumped at.

So we pitch up at the BBC Maida Vale studios, along with around 70 others, for an exclusive session, which was pretty amazing. Firstly the sounds was great; it is, after all, a recording studio, so has great acoustics. It was a short, but intense session, just over an hour of songs, with Bob interviewing Chris a couple of times during the set. He worked backwards, starting with his newer blues material and going back in time to his earlier hits, all of which were incredible. He's such a great guitarist; it's both inspiring (makes me want to play more) and depressing (I'll never be that good) at the same time. As always, it's truly amazing seeing a musician of that standard.

The weekend finished with a day at Silverstone with Dan (and thanks to Jane who conveniently double-booked herself so let me have her ticket), watching the final round of the British Touring Car Championship. A full day of great racing, with Silverstone at its best for the crowd - almost completely open everywhere. No restrictions on where you could sit, access to the paddock and no tight security or over-protected drivers. Back home to a large pot of stew to watch the penultimate race of the MotoGP with more excellent racing.

So this is thanks to Jon and Lou, and Dan and Jane. I owe you.

posted @ Monday, October 16, 2006 1:56 PM | Feedback (4)
Patch Tuesday, err, Friday

So patch Tuesday rolls by and my laptop installs the bundle of patches. On Thursday. Today the patches arrive on my main machine, so at 9:30am I start intalling them. It's just finished. The time? 15:48. What the heck was it doing?

Listening to Requiem by Verdi from the album Requiem Disc 1

posted @ Friday, October 13, 2006 3:52 PM | Feedback (3)
Sql Server Integration Services

I have decided that, as great and powerful as it is, SSIS sucks (but only a little). There are way too many little things that make working with it frustrating:

  • Why did they feel the need to invent a new type of drop down list, one that shows a modal form? When selecting input and output data sources, you are shown a drop down list of data source and clicking the arrow doesn't display what you normally get from this type of list, but a modal form shown the entries alongside tick boxes; the form also has a Cancel and OK button. It's confusing.
  • Error messages are generally not that helpful
  • Data conversion problems (which also relates to error messages). Consider the following message when creating a relationship between a derived column (and the data types aren't SQL ones - they are the OLEDB/SQLClient ones, making it more confusing) and a lookup column:

    "The following columns cannot be mapped: [x, y]. One or more columns do not have supported data types or their data types do not match"

    This is particularly useless; why doesn't it tell me what the data types are? They should be compatible as they are both strings, but obviously not. In fact one was unicode, one wasn't; simple to miss and I wish it could work things out a little more.
  • The languagesyntax disparity. I'm not sure this is a reall issue, but it seems weird to me. SSIS is a VS tool, so the language features (comparisons etc) use a C# style syntax, but I'm working with SQL so it seems as though I should be use SQL syntax.

I won't deny that SSIS is extremely powerful and very useful, but I think it needs spit and polish.

Listening to Throwing Fire at the Sun by Heather Nova from the album Oyster

posted @ Tuesday, October 10, 2006 5:11 PM | Feedback (4)
RedGate SQL Tools

I've seen the Red Gate SQL Tools used in the past, but not tried them myself until today, when I ventured into SQL Compare and SQL Data Compare. My word, these are good. Really, really good. Not only do they do their job well, but they are exceedingly simple to use; easy wizards and simple screens showing you what is to be compared and trasnferred. I can't believe I've never had these before. Shame on me. And shame on you if you haven't looked at them. Go on, do it now. You won't regret it.

posted @ Tuesday, October 03, 2006 5:13 PM | Feedback (1)
Pink for October

October is National Breast Cancer Awareness Month, so ipona has gone pink for October.

posted @ Monday, October 02, 2006 9:14 AM | Feedback (0)