Geeks With Blogs

The Wrecking Bawl Destructuring query language, one keyword at a time. June 2007 Entries
XML parsing error: An invalid character was found in text content.
So I was writing a script to pull out some old xml data, and I happened upon this error: XML parsing error: An invalid character was found in text content. It probably would have taken me centuries to figure out what character it didn't like, so I tried concatenating the following line to the front of the xml column in the SELECT statement I used to populate the cursor for openxml, and voila, no more error! I guess bumbles really do bounce. '<?xml version=''1.0'' encoding=''iso-8859-1''?>' ......

Posted On Friday, June 29, 2007 11:26 AM

the mind knows the time
I've officially eliminated the alarm clock from my daily awakening. I discovered a few years ago that if I look at the clock and tell myself that I want to wake up from a nap at a specific time, I would actually wake up at the correct time about 95% of the time. I've extended that to a full night's sleep the past couple weeks, though I haven't been taking note of the current time when I've gotten into bed. All I do is tell myself I want to wake up at 7:02 AM, for example, and I do. I don't really ......

Posted On Friday, June 29, 2007 5:55 AM

you should like, um, fear your government and stuff
This is great: "For the president to perform his constitutional duties, it is imperative that he receive candid and unfettered advice and that free and open discussions and deliberations occur among his advisors," Fielding said. How is this not an admission that people in the executive branch are saying things the public wouldn't want to hear? I guess the question is just how bad these things are, ......

Posted On Thursday, June 28, 2007 8:29 AM

centrist politicians poll
Take the pollFree Poll by Blog Flux ......

Posted On Thursday, June 21, 2007 7:27 AM

havarti and tuna
Havarti is the key to a great tuna salad sandwich.  Diced celery is also a wonderful addition.

Posted On Wednesday, June 20, 2007 9:04 AM

last modified date for stored procedure

I can't believe I just discovered the last_altered column in information_schema.routines in SQL Server 2005, all this time I thought there was no way to get the last modified date for a stored procedure.  Is there a catch?

Is Christmas really boring for the 7% of males who are red-green colorblind?


Posted On Monday, June 11, 2007 11:42 AM

SQL: OPENXML and case sensitivity
If you don't want to waste a lot of time figuring out why the results of your OPENXML query are all NULL, never forget that it's case sensitive.  I'm sure it's already obvious to those who use XML often and are acutely aware that it's case sensitive, but if you spend most of your time doing SQL you tend to forget about case sensitivity.

Posted On Thursday, June 7, 2007 8:43 AM

Copyright © Alex Bransky | Powered by: