Lee Kelleher

Archive for posts tagged with 'sql'

  1. Running Umbraco from a USB drive

    Posted on

    With the release of Umbraco 4.6 (Juno), users now have the option of using Microsoft’s new embedded database engine, SQL CE 4. This means that you don’t need to depend on using a database server (such as SQL Server [Express] or MySQL), you can run Umbraco exclusively from the file-system! Also recently released is IIS Express 7.5, (another Microsoft web technology, as part of their WebMatrix framework), which offers a lightweight version of IIS –…

    Tags: , , , , , , ,

  2. Convert XmlReader to String

    Posted on

    I was in the middle of developing a member look-up AJAX function for an Umbraco project, when I ran into a slight problem, (confusion rather), about how to pull the XML back from SQL Server and return it to the browser (AJAX). The SQL statement was straight-forward, very simple, does a LIKE query against the members table, no problem there. Added “FOR XML AUTO” to return the result-set back as an XML data-type ... all…

    Tags: , , , , , , ,

  3. All hail “The Bookninja Messiah”!

    Posted on

    Earlier this week I’d heard that Bookninja had been hijacked, they needed some help to get their WordPress back in working order. Mark suggested that I offered my services, so I did. George explained what the problems since the hijack: Unable to publish blog posts and pages; (a blank page appeared when he tried to publish) All the pages had been delete, or disappeared. Akismet was turned off… opening the floodgates to lots of unwanted…

    Tags: , , , , , , , , ,