(Scott Mitchell) In .NET applications, an illegal operation – an invalid cast, attempting to reference a null value, trying to connect to a database that’s been taken offline, and so on – raises an exception. Exceptions can be caught and handled directly in code through the use of Try / Catch blocks
Author: SSWUG Research
JavaScript XSLT Support in Firefox
(Nicholas Zakas) Beginning in Firefox 1.0, a new object called XSLTProcessor has been available to JavaScript developers in order to enable client-side XSLT transformations. This object uses Firefox’s built-in XSLT processor, Transformiix, to enable this functionality.
Visualizing Database Information with Tableau
(Ben Lorica) Tableau Software is a provider of visual analysis and reporting tools. Although there are several tools available to help users efficiently and easily create pivot tables or cross-tabulations, Tableau allows you to take it one step further: visualize the cross-tabulations in real time.
Podcast: Oracle security guru Peter Finnigan on the problem with PL/SQL
(Mark Brunelli) The protective wrapping around the programming language used to write procedures and commands in the Oracle Corp. database — PL/SQL — isn’t as ironclad as some might expect, says Pete Finnigan, a well known Oracle database security guru and blogger. In fact, says Finnigan, who also
An Introduction to LINQ – Part 3
(Thiru Thangarathinam) In the previous installment of this series on LINQ, you learned the basics of DLINQ and saw how to use it to retrieve data from the database. Specifically it focused on the retreival of relational data for display purposes. This installment will shift gears and focus on the XM
Finding the Most Typical Record in a Group
(Marcos M. Campos) I recently came across the following question: How can I find the most typical record in a group or cluster of records? For example, suppose we have a set of customer records, what is the customer that best typifies the group or cluster? The answer to this question can be used for
SQL and XQuery tutorial for IBM DB2, Part 7: Introduction to XML and XQuery
(Pat Moffatt, Bruce Creighton and Jessica Cao) This tutorial introduces pureXML and XQuery, starting from a basic overview of the characteristics and advantages of the XML data type, and then compares it with standard relational tables. Users are then asked to write XQueries to retrieve XML elements
SQL Server 2000 Collation Changer
(Alex Baker) Do you have a SQL application that you need to deploy in another country – do you need to change the collation of your SQL database and all objects in it? If the answer is yes, then this could be a very slow process to do manually.
Creating a Login Script for a PHP Invoicing System
(Leidago) In this first part of “Building an Invoicing System,” we are going to look at invoice management. Why would anyone want an online invoicing system? Well, if you are a freelance web developer like myself, you will undoubtedly need to invoice your clients so as to be able to get paid at the
XAML opens paradigm shift for application development
(George Lawton) Microsoft’s Extensible Application Markup Language (XAML) promises to usher in a new era in the development of applications by clearly delineating the different operations involved in building applications. As part of the Windows Presentation Foundation, XAML provides an infrastructu