(Adam Delves) In the first part of this series, we took a look at how PHP 5 can be used to manipulate and parse XML files. In this installment, we are going to focus on Ajax, one of the most useful and topical applications of XML.
Other News
Dr Michael Kay on Building XML Workflow Applications
A new tutorial entitled Building XML Workflow Applications, written by XML industry guru, Dr. Michael Kay — founder of Saxonica, the producer of the Saxon XQuery and XSLT processor — was announced today by Stylus Studio (http://www.stylusstudio.com), the industry-leading provider of XML development
Oracle releases out-of-cycle fix
(Robert McMillan) Oracle has released a critical security patch to the company’s E-Business Suite software.
X- and Y-Axis Transformations in SQL Server
(Alex Kozak) When I was writing code for user interfaces, I needed to present data in different ways. Logically it wasn’t difficult, but since the presentation layout was often quite different from the storage (tables’) structure, I had to use numerous record sets, loops, and arrays to manipulate th
Consuming a Web Service from a SQL Server 2005 CLR Assembly
(Julian Skinner) One advantage of CLR assemblies is the ability to consume web services from within the database. This wouldn’t be easy with T-SQL, and would also require a lot of work in an unmanaged extended stored procedure. With .NET, it’s almost as simple as accessing a local DLL.
Understand the impact of Sarbanes-Oxley compliance on your disaster recovery plan
(Mike Talon) No discussion of disaster recovery (DR) and compliance issues would be complete without looking at the Sarbanes-Oxley Act of 2002 (SOX). Originally designed to help avoid the irregular accounting situations made famous by companies like Enron, SOX was passed in 2002 to outline strict gu
Part 2 – How to easily populate a table with random data
(Chris Eaton) I got a bunch of questions on how to expand on the idea I showed in part 1 on how to easily populate a table with random data so I thought I would post a part 2 to answer some of these questions. I’m going to add in two additional techniques.
Delete duplicate rows from a table
(Natalka Roshak) There’s an Oracle-specific trick to delete the duplicates from a table.
Don’t trust your MySQL general query log if you don’t trust your users
(Beat Vontobel) I just stumbled across a recently discovered security issue in MySQL when I made use of the general query log today (which is usually deactivated on our servers) to track down the behaviour of some legacy applications: If you grant access to possibly untrusted users, you shouldn’t co
Extending an ASP.NET Datagrid to Support Simple Cross Tab Reporting: The Structure
(Jagadish Chaterjee) This article guides you through developing your own ASP.NET custom control by extending the existing datagrid control (in ASP.NET). It mainly concentrates on Cross Tab Reporting with the ASP.NET data grid.