-
Recent Posts
Archives
- July 2016
- April 2015
- January 2015
- October 2014
- September 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- January 2014
- August 2013
- March 2013
- February 2013
- January 2013
- December 2012
- June 2012
- April 2012
- March 2012
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
Categories
Blogroll
Meta
Author Archives: Jennifer Phillips Campbell
My T-SQL Bookmarks
T-SQL Built-in Functions Creating a User-Defined Function Unlike the output of a stored procedure, the result of a UDF can be accessed in a select statement While Loops
Posted in Databases
Leave a comment
Custom Functions in VBA
I had a nostalgic kind of week this week, working with VBA to create a custom function to apply some business logic to a calculation in a spreadsheet. I got into programming through working with VBA macros, and still find … Continue reading
Posted in Uncategorized
Leave a comment
jQuery and JavaScript for Debugging
Here are a few of the JavaScript and jQuery methods which I find useful when debugging my projects. JSON.stringify() can be used to inspect objects To inspect the value of element attributes like class or id, use .attr() e.g. $(‘#myelementid’).attr(‘class’) … Continue reading
Posted in JavaScript
Leave a comment
Using Rhino Mocks with Windows 7
There’s a very useful article by Stephen Walther here. Some parts do need to be updated, though: Rhino Mocks downloads have moved to hibernatingrhinos.com The warning about using assemblies downloaded from the internet in Windows Vista also applies to Windows … Continue reading
Posted in Uncategorized
Leave a comment
Displaying HTML-formatted documents without HTML
Most of the documents displayed on my genealogy website conform to one of a limited number of formats and I’ve created an HTML template for each format required. However, I also have some free-form text documents which I wanted to … Continue reading
Posted in JavaScript
Leave a comment
Testing Web Apps with Selenium
Inspiration can be found in the most unexpected places: about this time last year I was introduced to the Selenium suite of browser automation tools while chatting to an acquaintance at a wedding. Since then I’ve used two of the … Continue reading
Posted in Testing
Leave a comment
Selecting Child Elements in jQuery
I was recently asked whether it would be ‘better/quicker’ to replace $(‘ul’).children(‘li’).children(‘a’) with $(‘ul li a’) My initial response was to warn that these two lines of code don’t actually do the same thing. As explained in the jQuery API … Continue reading
Posted in JavaScript
1 Comment
From SQL to LINQ
Since I starting to work in C# 3.0 I’ve often had occasion to make use of LINQ (Language Integrated Query) queries to work with in-memory collections. My experience with SQL makes it natural for to me to think of this … Continue reading
Posted in Uncategorized
1 Comment
Symbols in Ruby
When I started to work with Ruby I was puzzled by the symbol – text preceded by a colon character, as in session[:cart] What exactly is a symbol, I wondered? And why is it used? I set out to find … Continue reading
Posted in Ruby on Rails
Leave a comment
Full-Text Search with SQL Server 2008
The full-text search capabilities of SQL Server 2008 make it possible to search text across multiple columns, weight search terms, and search by proximity. A full-text query can be much faster than the equivalent LIKE query. The first step is … Continue reading
Posted in SQL, SQL Server
Leave a comment
Jenny's Jottings 